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
Comments (0)
Trackbacks (0)
Leave a comment
Trackback