Encrypting Text

In SQL2K, I used to use the PWDENCRYPT() and PWDCOMPARE() to encrypt the
password and then compare when the user logs in.
In SQL 2005, seems that this function is not working, and I don't understand
the Symmetric key function. Can anyone please kindly give me some example?
Thanks in advance.
Regards,
Janet[url]http://www.sqlservercentral.com/columnists/mcoles/sql2005symmetricencryption.asp[/
url]
"Janet >" wrote:

> In SQL2K, I used to use the PWDENCRYPT() and PWDCOMPARE() to encrypt the
> password and then compare when the user logs in.
> In SQL 2005, seems that this function is not working, and I don't understa
nd
> the Symmetric key function. Can anyone please kindly give me some example
?
> Thanks in advance.
> Regards,
> Janet
>
>