Sunday, February 19, 2012

Column Encryption in Sql Server 2000

Are there any UDf's or Xtended stored procs available in sql server 2k that can encrypt a column that has the CC #'s or do I need to purchase a 3rd party tool ?

thanks,
DinakarHi ndinakar:

Nothing in SQL 2000.

Just as a side note, MS recently announced native encryption for SQL Server 2005.|||There is an undocumented function in SQL 2000, which allow to encrypt data, but it is one way hash, there is no way to decrypt it, so will not be suitable to store CC #, its better suited to store the passwords for compaison purpose.|||so how do people do it ? using 3rd party encryptioners ? anyone already doing it willing to share some of your xperience pls ?

TIA.

No comments:

Post a Comment