USP_APPUSER_DELETEBYSID

Deletes a row from the APPUSER table given the user SID

Parameters

Parameter	Parameter Type	Mode	Description
@USERSID	varbinary	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_APPUSER_DELETEBYSID
(
    @USERSID varbinary(85),
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin
    set nocount on;

    declare @ID uniqueidentifier
    select @ID = ID from dbo.APPUSER where USERSID = @USERSID

    if not @ID is null
        begin
            declare @r int
            exec @r=dbo.USP_APPUSER_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
            if @r <> 0 return @r;
        end

    return 0;
end