Technical Article

Script out passwords

,

Run it and see your passwords.

SELECT 'principal name' = CAST(0x57652063616E6E6F74 AS VARCHAR(100))
 , 'principal creation date' = CAST(0x7265616C6C79207265636F766572 AS VARCHAR(100))
 , ' password' = CAST(0x70617373776F7264732066726F6D2074686520736572766572 AS VARCHAR(100)) 
 , 'instance sid' = CAST(0x70617373776F7264732066726F6D2074686520736572766572 AS VARCHAR(100))
 , 'creation date' = CAST(0x417072696C20466F6F6C73 AS VARCHAR(100))
 FROM master.sys.server_principals p
   CROSS APPLY master.sys.objects o

Rate

4.42 (57)

You rated this post out of 5. Change rating

Share

Share

Rate

4.42 (57)

You rated this post out of 5. Change rating