Pasted

IF NOT EXISTS (SELECT TOP 1 1 FROM ObjectMainMessages WHERE ObjectName = 'FK_item_ILC_InfoCard' AND MessageType = 18)
    BEGIN
        DECLARE @NextMessageNo  int
        DECLARE @NextMessageNoNext  int
 
        SELECT @NextMessageNo   = ISNULL(MAX(messageno),799999) 
        FROM ApplicationMessages 
        WHERE MessageNo BETWEEN 800000 AND 999999
 
        SET @NextMessageNo = @NextMessageNo + 1
        SET @NextMessageNoNext = @NextMessageNo + 1
 
        ---add main message 404 = Cannot delete record. At least one &1 exists for this &2.
        EXEC AddObjectMainMessageSp 'FK_item_ILC_InfoCard', 18, 404, 16, 'Item to InfoCard FK violation', 0 
 
        --add the substitution text
        EXEC AddApplicationMessageSp @NextMessageNo, 'Item', N'1033'
        EXEC AddApplicationMessageSp @NextMessageNoNext, 'InfoCard', N'1033'
 
        --add substitution text to main message
        EXEC AddObjectBuildMessageSp 'FK_item_ILC_InfoCard', 18, 1, @NextMessageNo
        EXEC AddObjectBuildMessageSp 'FK_item_ILC_InfoCard', 18, 2, @NextMessageNoNext
    END