Encrypted fields in SQL server 2000

[varshan09]

Is there any way to specify any column as encrypted in SQL server 2000?

We have the requirement of storing passwords in the table and we want to store enrypted values of the passwords.

Any pointers will be appreciated!

Thanks
Varsha

 

[JamesLean]

Not natively. You will need to encrypt the values in your application before inserting them into the db.

--James

 

[micha123]

There are some 3rd party tools that help you do that, if the databases and applications already developed, and want the encryption-decryption to be "a black box".
For example, I've tested DBEncrypt tool for a big bank that didn't want the application to deal with the encryption-decryption thing:

http://www.appsecinc.com/products/dbencrypt/mssql/dbencrypt_demo_mssql.pdf

"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M.