update HD_InstanceConfigurations set [SendEmailToSupporters] = 1
update HD_InstanceConfigurations set [InstanceUrl] = ''
update HD_InstanceConfigurations set [TemplateTicketReadyForClosure] = ''
update HD_InstanceConfigurations set [TemplateSupporterAssigned] = ''
update HD_InstanceConfigurations set [TemplateCommentAdded] = ''

ALTER TABLE HD_InstanceConfigurations ALTER COLUMN [SendEmailToSupporters] bit NOT NULL
ALTER TABLE HD_InstanceConfigurations ALTER COLUMN [InstanceUrl] nvarchar(max) NOT NULL
ALTER TABLE HD_InstanceConfigurations ALTER COLUMN [TemplateTicketReadyForClosure] nvarchar(max) NOT NULL
ALTER TABLE HD_InstanceConfigurations ALTER COLUMN [TemplateSupporterAssigned] nvarchar(max) NOT NULL
ALTER TABLE HD_InstanceConfigurations ALTER COLUMN [TemplateCommentAdded] nvarchar(max) NOT NULL