several useful Store Procedures in MSSQL

sp_grantlogin @loginname
sp_grantdbaccess @loginname
sp_addmemberrole @rolename, @loginname

转载于:https://www.cnblogs.com/jonnyyu/archive/2005/07/07/188152.html