Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-27 : 08:22:13
|
| gopal writes "Hi, I am facing a problem with data encryption in sql server.Our clients want that some data of a table to be kept encrypted in the database.We are using some dll on the client side(asp) to encrypt data and then send it to sql server.When a user retrived the data using asp.net page then that data will be decripted and shown on the web page. But the problem we are facing is that when we 'Sort' the encrypted column then sorting is done according to the encrypted data not on the actual data! Now my question is that 'Is there any way in sql server?' to encrypt and decrypt data in the sql server itself.Thanks,Gopal" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-27 : 08:37:17
|
| There are third party solutions for this kind of thing. Have a look at:[url]http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=1&tabid=2[/url] |
 |
|
|
|
|
|
Encrypt and Decrypt Data in a Table