Encrypt

[accessman2]

Hi,

In SQL Server 2000, we have Encrypt, and pwdencrypt password.
Do we have Decrypt password?

select Encrypt('test') => 0x5400650073007400

select Decrypt('0x5400650073007400') => test
do we have function similar like this?
Because if the user forget the password, i can use decrypt function to convert it and then send it back the user.

Thanks.

 

[SQL_Hell]

There isn't a function that I know of that will do what you want, probably due to security reasons.
Personally I would just change the password.

It might be an idea to get some secure password software, or create a text file with the usernames/passwords in it and put it in a password protected .zip file that only you know the password too.