I m using SQL server 2000 and I want to use a password field for Employee Master. My question is how to encrypt this password field in my insert query. I have heard about the “EncryptByPassPhrase” function and symmetric key, but it is provided from SQL Server 2005. I have tried using pwdencrypt which is working, but how can I decrypt this encrypted password?
March 11, 2010 7:00 PM
March 19, 2010 2:14 PM