SQL Server Performance Forum – Threads Archive

encription

I need to store the number in the encripted form and then decript it when i access it.
Is there any function or method for this in SQL Server 2000. Let me also know the resouces where i can get more information on this.

---

Why don’t you do this with your client language? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

---

Simple method by using pwdencrypt,pwdcompare
more on
http://www.sqlservercentral.com/columnists/dasanka/saveyourpassword.asp
—————————————-
http://spaces.msn.com/members/dineshasanka

---

I can do this by client or server side script too but the thing is we are using SSL so the trasfer of data is secured and we want them to store the encripted data in database. Will try out the above link
Thanks and Regards
Pavas

---

I think by doing this from the client is the best rather than my suggestion. —————————————-
http://spaces.msn.com/members/dineshasanka

---

pwdencrypt and pwdcompare use one-way encryption. Since 2000 does not provide full "encryption" like the SQL 2005, you have to use your own. Fortunately for you (and those who needs it), there is a library (check out Michael Coleshttp://www.sqlservercentral.com/columnists/mcoles/freeencryption.asp). It is an extended stored procedure and can be used in SQL 2000. If you plant to upgrade into SQL 2005, check this outhttp://www.databasejournal.com/features/mssql/article.php/3483931. Hope this works.

---

Btw, there are several xp’s freely available to do encryption. Search for "sql server+ md5", for example. I haven’t got a link at hand right now. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

---

Thanks FrankKalis, I will look into this

---

Finally found the link I’ve had in mind:http://www.codeproject.com/database/xp_md5.asp —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

---

]]>