Home > SQL > Get User, Password and SID on MSSQL 2008 R2

Get User, Password and SID on MSSQL 2008 R2


select 'exec sp_addlogin['+name+'],',password_hash,',@sid=',sid,',@encryptopt=skip_encryption' from sys.sql_logins
Categories: SQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a comment