Encryption Decryption problem
-
Hi Friends , I want to create a table in which , i want to declare some fields as encrypted at the time of creation so that tha data entered in that fields could not be seen by anybody . Can you please guide me. Thanking you , Param.
param
-
Hi Friends , I want to create a table in which , i want to declare some fields as encrypted at the time of creation so that tha data entered in that fields could not be seen by anybody . Can you please guide me. Thanking you , Param.
param
param thaker wrote:
I want to create a table in which , i want to declare some fields as encrypted at the time of creation so that tha data entered in that fields could not be seen by anybody .
This is not possible in SQL Server 2000. It may be possible in SQL Server 2005, but I doubt it. Certainly you could use CLR stored procedures to encrypt and decrypt data, however doing so on key or indexed columns is not advisable because it will dramatically hurt the performance of your database.
Upcoming Scottish Developers events: * We are starting a series of events in Glasgow in 2007. Are you interested in a particular subject, or as a speaker? * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog | Photos