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_droprolemember(nvarchar @rolename, nvarchar @membername)
MetaData:
create procedure sys.sp_droprolemember @rolename sysname, @membername sysname 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 @membername if @ret <> 0 return(1) set @stmtR = 'alter role ' set @stmtR = @stmtR + quotename(@rolename, ']') set @stmtR = @stmtR + ' drop member ' set @stmtR = @stmtR + quotename(@membername, ']') -- issue DDL to create the role -- exec (@stmtR) if @@error <> 0 begin return (1) end -- RETURN SUCCESS -- return (0) -- sp_droprolemember
No comments:
Post a Comment