CREATE SERVER ROLE, ALTER SERVER ROLE and
DROP SERVER ROLE statements were added in SQL Server 2012 to facilitate the management of the new user-defined server roles. The following example uses the
CREATE SERVER ROLE statement to create a new Server Role named
CREATE SERVER ROLE [DbCreatorOnly]
ALTER SERVER ROLE statement can be used to change the membership of a server role or change names of a user—defined server role. For example, to assign a login named Chris to the new
DbCreatorOnly role, you can use the following:
ALTER SERVER ROLE [DbCreatorOnly] ADD MEMBER [Chris]
As mentioned earlier, user-defined roles can also be added ...