Archive

Archive for August, 2012

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