I was looking at the SQL Server 2008 Books Online topics for PWDENCRYPT and HASHBYTES. In the PWDENCRYPT topic is says:"Returns the SQL Server password hash of the input value that uses the current version of the password hashing algorithm. PWDENCRYPT is an older function and might not be supported in a future release of SQL Server. Use HASHBYTES instead. HASHBYTES provides more hashing algorithms."Looking in both the PWDENCRYPT and HASHBYTES topics (and other related topics), I cannot find what the "current version of the password hashing algorithm" is. How do I determine the "current version of the password hashing algorithm?"
View Complete Post