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