View difference between Paste ID: rNuafsde and Gwp5yNrP

-RAISERROR('10 Regenerate Replication Triggers',0,1) WITH NOWAIT
+IF @@SERVERNAME = 'DEVSQLSERVERNAME'
-GO
+BEGIN
-BEGIN -- 10 Regenerate Replication Triggers
+	DECLARE @EventParmId UNIQUEIDENTIFIER
-/*-----------------------------------------------
+
-10
+		,@SessionID UNIQUEIDENTIFIER
-Regenerate Replication Triggers for _App Databases
+
 		,@Infobar NVARCHAR(2800)
-Code similar to the following should be executed against
+
-all _App databases. The referenced event needs to be
+
-created in your LIVE _App databases so that it will be
+
-available in the TEST version after restore
+	BEGIN --SITE1
------------------------------------------------*/
+		USE [XX_SITE1_APP]
-IF @@SERVERNAME = 'SQLSERVERNAME'
+
- BEGIN
+
-	DECLARE
+
-		 @EventParmId UniqueIdentifier
+
 
-		,@SessionID UniqueIdentifier
+		EXEC dbo.InitSessionSp @SessionID
 			,'sa'
 
 		SELECT @EventParmId = NEWID()
 
 		EXEC @Severity = dbo.InsertEventInputParameterSp @EventParmId = @EventParmId
-	 BEGIN --MAIN
+			,@Name = N'TableNameVar'
-		USE [XX_MAIN_APP]
+			,@Value = ''
 			,@IsOutput = 0
 
-		EXEC dbo.InitSessionSp @SessionID, 'sa'
+		EXEC @Severity = dbo.InsertEventInputParameterSp @EventParmId = @EventParmId
 			,@Name = N'ServerNameVar'
 			,@Value = @@SERVERNAME
-		EXEC @Severity = dbo.InsertEventInputParameterSp
+			,@IsOutput = 0
-		  @EventParmId = @EventParmId
+
-		 ,@Name        = N'TableNameVar'
+		EXEC @Severity = dbo.InsertEventInputParameterSp @EventParmId = @EventParmId
-		 ,@Value       = ''
+			,@Name = N'DatabaseNameVar'
-		 ,@IsOutput    = 0
+			,@Value = @DBName
-		EXEC @Severity = dbo.InsertEventInputParameterSp
+			,@IsOutput = 0
-		  @EventParmId = @EventParmId
+
-		 ,@Name        = N'ServerNameVar'
+		EXEC @Severity = dbo.FireEventSp @eventName = N'ILC_RegenerateReplicationTriggers'
-		 ,@Value       = @@SERVERNAME
+			,@initiator = NULL
-		 ,@IsOutput    = 0
+			,@configName = 'XX_SITE1'
-		EXEC @Severity = dbo.InsertEventInputParameterSp
+			,@sessionID = @SessionID
-		  @EventParmId = @EventParmId
+			,@eventTrxId = NULL
-		 ,@Name        = N'DatabaseNameVar'
+			,@eventParmID = @EventParmId
-		 ,@Value       = @DBName
+			,@transactional = 0
-		 ,@IsOutput    = 0
+			,@generatingEventActionStateRowPointer = NULL
 			,@anyHandlersFailed = 0
-		EXEC @Severity = dbo.FireEventSp
+			,@result = @result OUTPUT
-		  @eventName = N'ILC_RegenerateReplicationTriggers'
+			,@Infobar = @Infobar OUTPUT
-		 ,@initiator = NULL
+
-		 ,@configName = 'BD_MAIN'
+		EXEC dbo.CloseSessionSp @SessionId
-		 ,@sessionID = @SessionID
+
-		 ,@eventTrxId = NULL
+
-		 ,@eventParmID = @EventParmId
+