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_revokelogin(nvarchar @loginame)MetaData:
create procedure sys.sp_revokelogin @loginame sysname AS -- SETUP RUNTIME OPTIONS / DECLARE VARIABLES -- set nocount on declare @exec_stmt nvarchar(4000) declare @ret int -- DISALLOW USER TRANSACTION -- set implicit_transactions off IF (@@trancount > 0) begin raiserror(15002,-1,-1,'sys.sp_revokelogin') return (1) end -- VALIDATE LOGIN NAME: execute @ret = sys.sp_validname @loginame if (@ret <> 0) return (1) -- DISALLOW SQL LOGIN (IE. MUST BE 'DOMAIN\USER') -- if (charindex('\', @loginame) = 0) begin raiserror(15407, -1, -1, @loginame) return (1) end set @exec_stmt = 'drop login ' + quotename(@loginame) exec (@exec_stmt) if @@error <> 0 return (1) -- RETURN "SUCCESS" -- return (0) -- sp_revokelogin
No comments:
Post a Comment