Search notes:

SQL Server: sp_addsrvrolemember

sp_addsrvrolemember adds a login to the set of members of a fixed server role.
exec sp_addsrvrolemember @loginname = …, @rolename = …
The procedure might be removed in a future version of SQL Server. Therefore, alter server role … should be used instead.

Index