SQL Server/T-SQL Tutorial/System Functions/sp DropSrvRoleMember
A statement that removes a user from a server role
<source lang="sql">
EXEC sp_DropSrvRoleMember JohnDoe, sysadmin</source>
The syntax for sp_DropSrvRoleMember
<source lang="sql">
sp_DropSrvRoleMember [@loginame = ] "login_ID",
[@rolename = ] "server_role_name"</source>