USP_EXCHANGEUSER_UPDATEWATERMARK

Updates the WATERMARK value for a given exchange user.

Parameters

Parameter	Parameter Type	Mode
@APPUSERID	uniqueidentifier	IN
@WATERMARK	nvarchar(500)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_EXCHANGEUSER_UPDATEWATERMARK
            (
                @APPUSERID uniqueidentifier, 
                @WATERMARK nvarchar(500),
                @CHANGEAGENTID uniqueidentifier
            )
            as            
                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                update 
                    dbo.EXCHANGEUSER    
                set
                    WATERMARK = @WATERMARK,
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = getdate()
                where
                    APPUSERID = @APPUSERID;