USP_EXCHANGESERVERAPPUSER_ADDAPPUSER

Adds an exchange service application user.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@IDENTIFIERTYPECODE	tinyint	IN
@EXCHANGESERVERID	uniqueidentifier	IN
@APPUSERID	uniqueidentifier	IN
@EMAILADDRESS	UDT_EMAILADDRESS	IN

Definition

Copy



            create procedure dbo.USP_EXCHANGESERVERAPPUSER_ADDAPPUSER
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @IDENTIFIERTYPECODE tinyint,
                @EXCHANGESERVERID uniqueidentifier,
                @APPUSERID uniqueidentifier,
                @EMAILADDRESS dbo.UDT_EMAILADDRESS
            )
            as
                set nocount on;

                declare @CURRENTDATE datetime

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

                if @ID is null
                    set @ID = newid();

                set @CURRENTDATE = getdate();

                if not exists(select ID from dbo.EXCHANGESERVERAPPUSER where EXCHANGESERVERAPPUSER.APPUSERID = @APPUSERID) begin
                    insert into dbo.EXCHANGESERVERAPPUSER
                        (ID, APPUSERID, EMAILADDRESS, IDENTIFIERTYPECODE, EXCHANGESERVERID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED) 
                    values 
                        (@ID, @APPUSERID, @EMAILADDRESS, @IDENTIFIERTYPECODE, @EXCHANGESERVERID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
                end;