USP_RECORDOPERATION_APPLICATIONUSERDISABLERUNAS

create procedure dbo.USP_RECORDOPERATION_APPLICATIONUSERDISABLERUNAS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
            set nocount on;

            if @CHANGEAGENTID is null  
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            update
                dbo.APPUSER
            set
                HASRUNASRIGHTS = 0,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = getdate()
            where
                APPUSER.ID = @ID;

            return 0;
end