USP_EXCHANGESERVER_WATERMARK_UPDATE

Executes the "Exchange Server Watermark: Update" record operation.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy


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

                        begin try
                            update 
                                dbo.EXCHANGEUSER 
                            set 
                                WATERMARK = ''
                            where 
                                EXCHANGEUSER.APPUSERID in (
                                    select 
                                        EXCHANGESERVERAPPUSER.APPUSERID
                                    from
                                        dbo.EXCHANGESERVERAPPUSER
                                    where 
                                        EXCHANGESERVERAPPUSER.EXCHANGESERVERID = @ID
                                );
                            return 0;
                        end try

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