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