Pasted

IF @@SERVERNAME = 'DEVSQLSERVERNAME'
BEGIN
    DECLARE @EventParmId UNIQUEIDENTIFIER
        ,@Severity INT
        ,@SessionID UNIQUEIDENTIFIER
        ,@result NVARCHAR(MAX)
        ,@Infobar NVARCHAR(2800)
        ,@i INTEGER
        ,@DBName NVARCHAR(255)
 
    BEGIN --SITE1
        USE [XX_SITE1_APP]
 
        SELECT @SessionID = NEWID()
 
        SET @DBName = DB_NAME()
 
        EXEC dbo.InitSessionSp @SessionID
            ,'sa'
 
        SELECT @EventParmId = NEWID()
 
        EXEC @Severity = dbo.InsertEventInputParameterSp @EventParmId = @EventParmId
            ,@Name = N'TableNameVar'
            ,@Value = ''
            ,@IsOutput = 0
 
        EXEC @Severity = dbo.InsertEventInputParameterSp @EventParmId = @EventParmId
            ,@Name = N'ServerNameVar'
            ,@Value = @@SERVERNAME
            ,@IsOutput = 0
 
        EXEC @Severity = dbo.InsertEventInputParameterSp @EventParmId = @EventParmId
            ,@Name = N'DatabaseNameVar'
            ,@Value = @DBName
            ,@IsOutput = 0
 
        EXEC @Severity = dbo.FireEventSp @eventName = N'ILC_RegenerateReplicationTriggers'
            ,@initiator = NULL
            ,@configName = 'XX_SITE1'
            ,@sessionID = @SessionID
            ,@eventTrxId = NULL
            ,@eventParmID = @EventParmId
            ,@transactional = 0
            ,@generatingEventActionStateRowPointer = NULL
            ,@anyHandlersFailed = 0
            ,@result = @result OUTPUT
            ,@Infobar = @Infobar OUTPUT
 
        EXEC dbo.CloseSessionSp @SessionId
    END
END
GO