The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_dropsrvrolemember(nvarchar @loginame, nvarchar @rolename)
MetaData:
-- FOR BACKWARD COMPATIBILTY ONLY -- create procedure sys.sp_dropsrvrolemember @loginame sysname, -- login name @rolename sysname = NULL -- server role name as -- SETUP RUNTIME OPTIONS / DECLARE VARIABLES -- set nocount on declare @ret int, -- return value of sp call @stmtR nvarchar(4000) -- Was a part of check to prevent inside a user Xact. Leave for backward compat.-- set implicit_transactions off exec @ret = sys.sp_validname @rolename if @ret <> 0 return(1) exec @ret = sys.sp_validname @loginame if @ret <> 0 return(1) set @stmtR = 'alter server role ' set @stmtR = @stmtR + quotename(@rolename, ']') set @stmtR = @stmtR + ' drop member ' set @stmtR = @stmtR + quotename(@loginame, ']') -- issue DDL to create the role -- exec (@stmtR) if @@error <> 0 begin return (1) end -- RETURN SUCCESS -- return (0) -- sp_dropsrvrolemember
No comments:
Post a Comment