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