• http://sqlity.net/en/2460/sql-password-hash/

    This article says sha1 from sql2000 and sha_512 from sql 2012.