if not exists(select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'AuditServiceFailedItems' and COLUMN_NAME = 'error_message') alter table auditlog.AuditServiceFailedItems add [error_message] nvarchar(4000) null