Shulou(Shulou.com)06/01 Report--

SQL Server exports statements that only create users through task scripts, and no password is painful in the migration process. So the official website provides a stored procedure sp_help_revlogin, please send export account and password. Just find the account you want and restore it in B (recovery machine).

Open USE masterGOIF OBJECT_ID ('sp_hexadecimal') IS NOT NULL DROP PROCEDURE sp_hexadecimalGOCREATE PROCEDURE sp_hexadecimal @ binvalue varbinary, @ hexvalue varchar OUTPUTASDECLARE @ charvalue varchar DECLARE @ I intDECLARE @ length intDECLARE @ hexstring char SELECT @ charvalue =' 0x'SELECT @ I = 1SELECT @ length = DATALENGTH (@ binvalue) SELECT @ hexstring = '0123456789ABCDEF'WHILE (@ I)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.