USP_BBNC_UPDATEUSERMAPPING

Updates the Blackbaud Internet Solutions User mapping.

Parameters

Parameter	Parameter Type	Mode
@OLDNAME	nvarchar(50)	IN
@NEWNAME	nvarchar(50)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure [dbo].[USP_BBNC_UPDATEUSERMAPPING]
            (
                @OLDNAME nvarchar(50),
                @NEWNAME nvarchar(50),
                @CHANGEAGENTID uniqueidentifier = null

            )
            as
            set nocount on;

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

            begin try
                update dbo.BBNCUSERMAP set BBNCUSERNAME=@NEWNAME, 
                    CHANGEDBYID = @CHANGEAGENTID, 
                    DATECHANGED = getdate()  where BBNCUSERNAME=@OLDNAME ;
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;