USP_RECORDOPERATION_GLOBALCHANGEPROCESSUSECURRENTAPPUSERID_TOGGLESETTING

                    create procedure dbo.USP_RECORDOPERATION_GLOBALCHANGEPROCESSUSECURRENTAPPUSERID_TOGGLESETTING
                    (
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as
                    set nocount on;

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

                    declare @OLDVALUE as nvarchar(50) = (select dbo.UFN_APPSETTING_GET('USECURRENTAPPUSERIDFORGLOBALCHANGEPROCESS'));
                    declare @NEWVALUE as nvarchar(1) = 
                    (
                    select 
                    case when @OLDVALUE = '0' then '1'
                    when @OLDVALUE = '1' then '0'
                    else '0'
                    end
                    );
                    begin try
                        exec dbo.USP_APPSETTING_ADDORUPDATE 
                            @NAME = 'USECURRENTAPPUSERIDFORGLOBALCHANGEPROCESS', 
                            @VALUE = @NEWVALUE,
                            @CHANGEAGENTID = @CHANGEAGENTID;

                        return 0;
                    end try                    
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch