This stored procedure associates a login to one of the pre-defined SQL Server Roles. The gist of this is to provide more granular audit security.
sp_addsrvrolemember
sp_addsrvrolemember [ @loginame= ] 'login'
, [ @rolename = ] 'role'
GO
Role Must Be One of the Following
sysadmin
securityadmin
serveradmin
setupadmin
processadmin
diskadmin
dbcreator
bulkadmin
--returns 0=ok 1=failed
EXEC sp_addsrvrolemember 'RENTON\BillP', 'sysadmin'; GO
The role membership of the sa and public logins cannot be modified!
Collapse All 
Expand All