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