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