IF NOT EXISTS (SELECT 1 FROM [sys].[columns] WHERE [object_id] = OBJECT_ID(N'[dbo].[ConnectionLog]') AND [name] = N'AssetElementInternalID')
    ALTER TABLE [dbo].[ConnectionLog] ADD [AssetElementInternalID] BIGINT NULL;