SQL Server/T-SQL Tutorial/System Functions/sp DropSrvRoleMember
Версия от 16:46, 26 мая 2010; (обсуждение)
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>