Pasted

IF @@SERVERNAME = 'DEVSQLSERVERNAME'
BEGIN
    DECLARE @EventParmId UNIQUEIDENTIFIER
        ,@Severity INT
        ,@SessionID UNIQUEIDENTIFIER
        ,@result NVARCHAR(MAX)
        ,@Infobar NVARCHAR(2800)
        ,@LicText NVARCHAR(MAX)
        ,@i INTEGER
 
    BEGIN -- SITE1
        USE [XX_SITE1_APP]
 
        SELECT @SessionID = NEWID()
 
        EXEC dbo.InitSessionSp @SessionID
            ,'sa'
 
        SELECT @EventParmId = NEWID()
 
        SELECT @LicText = BulkColumn
        FROM OpenRowSet(BULK 'G:\Licenses\XX_\DEVSERVERNAME\XX_SITE1_APP\License.txt', Single_Clob) AS X
 
        --PRINT @LicText
        EXEC @Severity = dbo.InsertEventInputParameterSp @EventParmId = @EventParmId
            ,@Name = N'LicenseDocument'
            ,@Value = @LicText
            ,@IsOutput = 0
 
        EXEC @Severity = dbo.FireEventSp @eventName = N'ILC_ApplyLicense'
            ,@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
 
    BEGIN -- SITE2
        USE [XX_SITE2_APP]
 
        SELECT @SessionID = NEWID()
 
        EXEC dbo.InitSessionSp @SessionID
            ,'sa'
 
        SELECT @EventParmId = NEWID()
 
        SELECT @LicText = BulkColumn
        FROM OpenRowSet(BULK 'G:\Licenses\XX_\DEVSERVERNAME\XX_SITE2_APP\License.txt', Single_Clob) AS X
 
        --PRINT @LicText
        EXEC @Severity = dbo.InsertEventInputParameterSp @EventParmId = @EventParmId
            ,@Name = N'LicenseDocument'
            ,@Value = @LicText
            ,@IsOutput = 0
 
        EXEC @Severity = dbo.FireEventSp @eventName = N'ILC_ApplyLicense'
            ,@initiator = NULL
            ,@configName = 'XX_SITE2'
            ,@sessionID = @SessionID
            ,@eventTrxId = NULL
            ,@eventParmID = @EventParmId
            ,@transactional = 0
            ,@generatingEventActionStateRowPointer = NULL
            ,@anyHandlersFailed = 0
            ,@result = @result OUTPUT
            ,@Infobar = @Infobar OUTPUT
 
        EXEC dbo.CloseSessionSp @SessionId
    END
END