decrypt function in SQL Server 2000

I know that there are undocumented encryption function, such as:
pwdencrypt
pwdcompare
anyone know what is the decrypt function in SQL Server 7.0/2000. If you know
any, please provide syntax and some simple examples.
Thanks a lotHi,
THose function are undocumeted and may not be available in next version.
refer the below site:-
http://www.activecrypt.com/
Thanks
Hari
SQL Server MVP
"jzhou" <jzhou@.discussions.microsoft.com> wrote in message
news:0DC77411-9710-4A06-A502-EE1DC61DAE54@.microsoft.com...
>I know that there are undocumented encryption function, such as:
> pwdencrypt
> pwdcompare
> anyone know what is the decrypt function in SQL Server 7.0/2000. If you
> know
> any, please provide syntax and some simple examples.
> Thanks a lot|||To add to Hari's response, undocumented functionality can change between
versions or even service packs and thus break your code. Avoid using
undocumented stuff in production.
Hope this helps.
Dan Guzman
SQL Server MVP
"jzhou" <jzhou@.discussions.microsoft.com> wrote in message
news:0DC77411-9710-4A06-A502-EE1DC61DAE54@.microsoft.com...
>I know that there are undocumented encryption function, such as:
> pwdencrypt
> pwdcompare
> anyone know what is the decrypt function in SQL Server 7.0/2000. If you
> know
> any, please provide syntax and some simple examples.
> Thanks a lot|||The others have explained why you shouldn't use this undocumented feature. T
o
answer your original question, there is no corresponding decrypt SP because,
despite the name, pwdencrypt isn't in fact an encryption function. pwdencryp
t
generates a hash (not a very secure one apparently) so you can't actually
"decrypt" it.
David Portas
SQL Server MVP
--