Unknown Function pwdcompare() & pwdencrypt()?

[essa2000]

Dears ;
Is there anyone who can explain following two function which have been used in a system stored procedure sp_Password and I have seen both these function in one of unknown developer's stored procedure.

pwdcompare()
pwdencrypt()

I don't know what are these function although I know that what is the function of both these function.

Please help me b/c I have to use both these function in checking password and saving password after encryption.

Regards,
essa2000

 

[tlbroadbent]

Most SQL experts advise against using these functions. The following quote is from the SQL FAQ on SWYNK.com.

"There are undocumented pwdencrypt() and pwdcompare() functions - they are for MS internal use and their function is likely to change/break in future - people who ignored advice and used them in 6.x applications have reported problems using them in SQL 7.0 Beta's.

"As many people now know about these functions they are mentioned here for completeness, but if you use these functions you will not receive support from Microsoft and will be completely on your own when you got problems with a new SP/version."

If you insist on using the functions, you can read more about them at

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9809.

Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot