Error in Website Log complaining about Collation conflict.

If you get this error when checking the Website Log.

2021-03-10 13:59:55.3329 - System.Data.SqlClient.SqlException (0x80131904): Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in add operator occurring in SELECT statement column 2.

Run the SQL Script "Quick Fix Collation" on the relevant database. Copy of content below.

ALTER TABLE [dbo].[Employees] ALTER COLUMN [SocialSecurityNumber] NVARCHAR(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [CarPlateNumber] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [VisitCompanyName] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [VisitSiteName] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [VisitAddressLine1] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [VisitAddressLine2] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [VisitCity] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [VisitCounty] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [VisitPostCode] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[WorkActivities] ALTER COLUMN [Address] NVARCHAR(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[WorkActivities] ALTER COLUMN [ZipCode] NVARCHAR(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[sy_dbsettings] ALTER COLUMN [Setting_key] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [CarPlateNumber] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[DeviceWorkCodes] ALTER COLUMN [WorkCode] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[DeviceWorkCodes] ALTER COLUMN [WorkCodeDescription] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[FaceTemplates] ALTER COLUMN [Template] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClockingScheduledActivities] ALTER COLUMN [Notes] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClockingScheduledActivities] ALTER COLUMN [JobReference] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ReportNotifications] ALTER COLUMN [Name] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ReportNotifications] ALTER COLUMN [NotificationTitle] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ReportNotifications] ALTER COLUMN [NotificationText] NVARCHAR(2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ReportNotifications] ALTER COLUMN [Counters] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [Lastname] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [Firstname] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[VisitorTypes] ALTER COLUMN [Color] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[GlobalNotifications] ALTER COLUMN [LocalizationKeyName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[GlobalNotifications] ALTER COLUMN [MessageValues] NVARCHAR(500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[sy_dbsettings] ALTER COLUMN [Setting_key] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ReceiptStatus] ALTER COLUMN [Name] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[JobSheets] ALTER COLUMN [Code] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[JobSheets] ALTER COLUMN [Title] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[JobSheets] ALTER COLUMN [Template] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[CardTemplates] ALTER COLUMN [Code] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[CardTemplates] ALTER COLUMN [Title] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[CardTemplates] ALTER COLUMN [TemplateFront] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[CardTemplates] ALTER COLUMN [TemplateBack] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[FaceTemplates] ALTER COLUMN [Template] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[CustomPayrollDepartmentGroups] ALTER COLUMN [Description] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[CustomPayrollDepartmentGroups] ALTER COLUMN [Departments] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ExpensePaymentCategories] ALTER COLUMN [Name] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[VisitorCustomFieldsValues] ALTER COLUMN [Value] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorNotes] ALTER COLUMN [NoteText] NVARCHAR(500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[VisitorNotes] ALTER COLUMN [CreatedBy] NVARCHAR(200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ManualTimesheets] ALTER COLUMN [Explanation] NVARCHAR(200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ManualTimesheets] ALTER COLUMN [UpdatedBy] VARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ManualTimesheets] ALTER COLUMN [ManagerNote] NVARCHAR(500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ExpenseMileagePeriods] ALTER COLUMN [PeriodName] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[DeviceFirmwares] ALTER COLUMN [Firmware] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[RosterNotificationTemplates] ALTER COLUMN [Name] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[RosterNotificationTemplates] ALTER COLUMN [Subject] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[RosterNotificationTemplates] ALTER COLUMN [Message] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Countries] ALTER COLUMN [CountryCode] VARCHAR(2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Countries] ALTER COLUMN [CountryName] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[UserPasswordHistory] ALTER COLUMN [Password] NVARCHAR(1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Clients] ALTER COLUMN [AccountCode] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Clients] ALTER COLUMN [ExportCode] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Clients] ALTER COLUMN [Code] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ExpenseDocuments] ALTER COLUMN [FileName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ExpenseDocuments] ALTER COLUMN [FileContentType] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[AbsenceRequestsLogs] ALTER COLUMN [Note] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[EmployeeAssignedContracts] ALTER COLUMN [UpdatedBy] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[AbsenceRequests] ALTER COLUMN [Note] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorFormQuestions] ALTER COLUMN [Text] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[VisitorFormQuestions] ALTER COLUMN [VisibleVisitorTypeIds] NVARCHAR(150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorFormQuestions] ALTER COLUMN [AnswerWhenSignInDenied] NVARCHAR(1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [Lastname] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [Firstname] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[RosterNotificationLogs] ALTER COLUMN [Message] TEXT COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[EmployeeQualifications] ALTER COLUMN [FileName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[EmployeeQualifications] ALTER COLUMN [FileContentType] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [MAC] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [CameraName] NVARCHAR(200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [DevicePublicKey] NVARCHAR(2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [DevicePrivateKey] NVARCHAR(2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [ConsultationUrl] NVARCHAR(500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [Note] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [ClientLogoFileName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [ClientLogoFileContentType] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [BackgroundImageFileName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [BackgroundImageFileContentType] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [DisclaimerText] NVARCHAR(4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [DisclaimerVideo] NVARCHAR(1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [DisclaimerDocumentFileName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [DisclaimerDocumentFileContentType] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [EndMessage] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[EmployeeExpenses] ALTER COLUMN [FromLocation] NVARCHAR(400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[EmployeeExpenses] ALTER COLUMN [ToLocation] NVARCHAR(400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[EmployeeExpenses] ALTER COLUMN [UpdatedBy] VARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ManualTimesheetPauses] ALTER COLUMN [UpdatedBy] VARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorFormQuestionOptions] ALTER COLUMN [Text] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[IrEnrolments] ALTER COLUMN [Badge] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [SignOutEndMessage] NVARCHAR(4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [TemplatesSyncTimes] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [EnrollerAgentDomain] NVARCHAR(150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [SyqrPin] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [PrinterIP] NVARCHAR(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [PrinterMacAddress] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [PrinterSerialNumber] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClearTransactionDataLogs] ALTER COLUMN [LogMessage] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ClientSites] ALTER COLUMN [SiteName] NVARCHAR(150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ClientSites] ALTER COLUMN [Name] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientSites] ALTER COLUMN [Company] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientSites] ALTER COLUMN [Email] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientSites] ALTER COLUMN [Address] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientSites] ALTER COLUMN [City] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientSites] ALTER COLUMN [Country] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientSites] ALTER COLUMN [Postcode] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientSites] ALTER COLUMN [ContactNumber] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[LapiAccessLogs] ALTER COLUMN [CarPlate] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[LapiAccessLogs] ALTER COLUMN [CameraName] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[LapiAccessLogs] ALTER COLUMN [Message] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[AbsenceRequestDetails] ALTER COLUMN [AbsenceManagerMessage] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[AbsenceRequestDetails] ALTER COLUMN [UpdatedBy] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ReportNotificationLogs] ALTER COLUMN [Subject] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ReportNotificationLogs] ALTER COLUMN [Message] NVARCHAR(2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ReportNotificationLogs] ALTER COLUMN [Emails] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[PaymentType] ALTER COLUMN [Name] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ac_securitygroup_employees] ALTER COLUMN [UpdatedBy] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClockingActivitySignatures] ALTER COLUMN [FileName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClockingActivitySignatures] ALTER COLUMN [FileContentType] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClockingActivitySignatures] ALTER COLUMN [ClientName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClockingActivitySignatures] ALTER COLUMN [ClientEmail] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClockingScheduledActivities] ALTER COLUMN [Notes] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClockingScheduledActivities] ALTER COLUMN [CreatedBy] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClockingScheduledActivities] ALTER COLUMN [JobReference] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[DeviceSyncTasks] ALTER COLUMN [Code] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[DeviceSyncTasks] ALTER COLUMN [Badge] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[SoftwareMainOptions] ALTER COLUMN [AbsenceRequestApprovedNotificationEmails] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorFormAnswers] ALTER COLUMN [Answer] NVARCHAR(1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorFormAnswers] ALTER COLUMN [SignatureFileName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorFormAnswers] ALTER COLUMN [SignatureFileContentType] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorCustomFieldListItems] ALTER COLUMN [ListItemValue] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ExpenseMileages] ALTER COLUMN [AdjustmentNote] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ScoresAbnormalitiesSetup] ALTER COLUMN [Name] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[VisitorSettings] ALTER COLUMN [ClientLogoFileName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorSettings] ALTER COLUMN [ClientLogoFileContentType] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorSettings] ALTER COLUMN [BackgroundImageFileName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorSettings] ALTER COLUMN [BackgroundImageFileContentType] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorSettings] ALTER COLUMN [CheckInFormTitle] NVARCHAR(500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorSettings] ALTER COLUMN [CheckOutFormTitle] NVARCHAR(500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorSettings] ALTER COLUMN [SynergyAppMainScreenFontColor] NVARCHAR(10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[VisitorSettings] ALTER COLUMN [SynergyAppMainScreenWelcomeText] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[EmployeeSwipes] ALTER COLUMN [ErrorMessage] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[EmployeeSwipes] ALTER COLUMN [DeviceIp] NVARCHAR(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[RecapAbsences] ALTER COLUMN [PreviousPeriodBalanceNote] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[RecapAbsences] ALTER COLUMN [QuotaNote] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[RecapAbsences] ALTER COLUMN [AdjustmentNote] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[RecapAbsences] ALTER COLUMN [UpdatedBy] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[Absence] ALTER COLUMN [Name] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Absence] ALTER COLUMN [ExportCode] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Buildings] ALTER COLUMN [Name] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[SygmaTemplates] ALTER COLUMN [TemplateName] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[SygmaTemplates] ALTER COLUMN [Front] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[SygmaTemplates] ALTER COLUMN [End] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ExpenseTypes] ALTER COLUMN [AccountCode] NVARCHAR(10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ExpenseTypes] ALTER COLUMN [ExportCode] NVARCHAR(10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[SyqrNotifications] ALTER COLUMN [NotificationText] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Currencies] ALTER COLUMN [Country] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Currencies] ALTER COLUMN [Name] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Currencies] ALTER COLUMN [AlphabeticCode] CHAR(3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Currencies] ALTER COLUMN [NumericCode] CHAR(3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ExpenseVehicleTypes] ALTER COLUMN [Name] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[VisitorCustomFields] ALTER COLUMN [Name] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ExpenseRates] ALTER COLUMN [Name] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ExpenseTypeGroups] ALTER COLUMN [Name] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[EmployeeTips] ALTER COLUMN [SourceName] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientContacts] ALTER COLUMN [ContactName] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ClientContacts] ALTER COLUMN [Email] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientContacts] ALTER COLUMN [Address] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientContacts] ALTER COLUMN [City] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientContacts] ALTER COLUMN [Country] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientContacts] ALTER COLUMN [Postcode] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClientContacts] ALTER COLUMN [ContactNumber] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ClockingActivities] ALTER COLUMN [ReferenceNo] NVARCHAR(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[WorkActivityExceptionRules] ALTER COLUMN [Name] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Inventory] ALTER COLUMN [Description] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Inventory] ALTER COLUMN [ExportCode] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Inventory] ALTER COLUMN [Color] NVARCHAR(6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Inventory] ALTER COLUMN [ReferenceNo] NVARCHAR(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[LapiCarPlate] ALTER COLUMN [Make] NVARCHAR(200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[LapiCarPlate] ALTER COLUMN [Color] NVARCHAR(200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[LapiCarPlate] ALTER COLUMN [CreatedBy] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[LapiCarPlate] ALTER COLUMN [UpdatedBy] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[LapiVehicleType] ALTER COLUMN [Name] NVARCHAR(150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[LapiVehicleGroup] ALTER COLUMN [Name] NVARCHAR(150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Positions] ALTER COLUMN [Type] VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[User] ALTER COLUMN [ResetPasswordCode] NVARCHAR(1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[User] ALTER COLUMN [OneTimePassword] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Departments] ALTER COLUMN [Color] NVARCHAR(6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[WorkActivities] ALTER COLUMN [UpdatedBy] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[ActivityMachine] ALTER COLUMN [Code] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ActivityMachine] ALTER COLUMN [Description] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[SoftwareMainOptions] ALTER COLUMN [FireBoardUserName] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[SoftwareMainOptions] ALTER COLUMN [FireBoardPassword] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[SoftwareMainOptions] ALTER COLUMN [FireBoardNormalValue] NVARCHAR(10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[SoftwareMainOptions] ALTER COLUMN [FireBoardRecieverEmails] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[SoftwareMainOptions] ALTER COLUMN [FireBoardEmailTemplate] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[SoftwareMainOptions] ALTER COLUMN [LapiOpenCamerasImportIpAddress] NVARCHAR(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [ContactEmail] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Employees] ALTER COLUMN [ContactNumber] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[EmployeeQualificationNotificationLogs] ALTER COLUMN [Message] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [Color] NVARCHAR(6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[LapiSecurityGroup] ALTER COLUMN [Name] NVARCHAR(150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[User] ALTER COLUMN [Password] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[LapiTimeZone] ALTER COLUMN [Name] NVARCHAR(150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [QrScannerType] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [VideoUrl] NVARCHAR(1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [PortalUrl] NVARCHAR(500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [FireLinkLastStatus] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Devices] ALTER COLUMN [SynergyClientId] NVARCHAR(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ALTER TABLE [dbo].[Rosters] ALTER COLUMN [Name] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ActivityMachineGroups] ALTER COLUMN [Name] NVARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[ContractHoursLimits] ALTER COLUMN [Name] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[LapiCameras] ALTER COLUMN [CameraANPR_Name] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[AccessControlEventNotificationLogs] ALTER COLUMN [Subject] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[AccessControlEventNotificationLogs] ALTER COLUMN [Message] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[AccessControlEventNotificationLogs] ALTER COLUMN [ToEmail] NVARCHAR(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Qualifications] ALTER COLUMN [Name] VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ALTER TABLE [dbo].[Qualifications] ALTER COLUMN [Description] VARCHAR(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO /****** Object: Index [UIX_ReportNotifications_Code] Script Date: 6/23/2020 12:17:21 PM ******/ DROP INDEX [UIX_ReportNotifications_Code] ON [dbo].[ReportNotifications] GO ALTER TABLE [dbo].[ReportNotifications] ALTER COLUMN [Code] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL GO /****** Object: Index [UIX_ReportNotifications_Code] Script Date: 6/23/2020 12:17:21 PM ******/ CREATE UNIQUE NONCLUSTERED INDEX [UIX_ReportNotifications_Code] ON [dbo].[ReportNotifications] ( [Code] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE [dbo].[VisitorTypes] DROP CONSTRAINT [UN_VisitorType] GO ALTER TABLE [dbo].[VisitorTypes] ALTER COLUMN [VisitorType] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL GO /****** Object: Index [UN_VisitorType] Script Date: 6/23/2020 11:32:01 AM ******/ ALTER TABLE [dbo].[VisitorTypes] ADD CONSTRAINT [UN_VisitorType] UNIQUE NONCLUSTERED ( [VisitorType] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO --special case for constraints with auto generated names --each DB will have own constraint name declare @table_name nvarchar(256) declare @column_name nvarchar(256) declare @dropConstraintCommand nvarchar(1000) set @table_name = N'Positions' set @column_name = N'Description' select @dropConstraintCommand = 'ALTER TABLE [' + @table_name + '] DROP CONSTRAINT ' + d.name from sys.tables t join sys.key_constraints d on d.parent_object_id = t.object_id join sys.columns c on c.object_id = t.object_id where t.name = @table_name and c.name = @column_name and d.name like 'UQ__Position__%' execute (@dropConstraintCommand) go ALTER TABLE [dbo].[Positions] ALTER COLUMN [Description] VARCHAR(255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL GO ALTER TABLE [dbo].[Positions] ADD CONSTRAINT [UQ_Positions_Description] UNIQUE CLUSTERED ( [Description] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO --special case for constraints with auto generated names --each DB will have own constraint name declare @table_name nvarchar(256) declare @column_name nvarchar(256) declare @dropConstraintCommand nvarchar(1000) set @table_name = N'LapiCarPlate' set @column_name = N'PlateNumber' select @dropConstraintCommand = 'ALTER TABLE [' + @table_name + '] DROP CONSTRAINT ' + d.name from sys.tables t join sys.key_constraints d on d.parent_object_id = t.object_id join sys.columns c on c.object_id = t.object_id where t.name = @table_name and c.name = @column_name and d.name like 'UQ__LapiCarP__%' execute (@dropConstraintCommand) go ALTER TABLE [dbo].[LapiCarPlate] ALTER COLUMN [PlateNumber] NVARCHAR(20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL GO ALTER TABLE [dbo].[LapiCarPlate] ADD CONSTRAINT [UQ_LapiCarPlate_PlateNumber] UNIQUE NONCLUSTERED ( [PlateNumber] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [PK_StaticReportsFavorites] Script Date: 6/23/2020 12:05:44 PM ******/ ALTER TABLE [dbo].[StaticReportsFavorites] DROP CONSTRAINT [PK_StaticReportsFavorites] GO ALTER TABLE [dbo].[StaticReportsFavorites] ALTER COLUMN [ReportName] NVARCHAR(128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL /****** Object: Index [PK_StaticReportsFavorites] Script Date: 6/23/2020 12:05:44 PM ******/ ALTER TABLE [dbo].[StaticReportsFavorites] ADD CONSTRAINT [PK_StaticReportsFavorites] PRIMARY KEY CLUSTERED ( [UserId] ASC, [ReportName] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO EXEC sys.sp_dropextendedproperty @name=N'LastRebuildDate' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EmployeeSwipes', @level2type=N'INDEX',@level2name=N'IX_EmployeeSwipes_Date' GO /****** Object: Index [IX_EmployeeSwipes_Date] Script Date: 6/23/2020 12:12:53 PM ******/ DROP INDEX [IX_EmployeeSwipes_Date] ON [dbo].[EmployeeSwipes] GO ALTER TABLE [dbo].[EmployeeSwipes] ALTER COLUMN [Badge] NVARCHAR(15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL GO ALTER TABLE [dbo].[EmployeeSwipes] ALTER COLUMN [ActivityCode] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO /****** Object: Index [IX_EmployeeSwipes_Date] Script Date: 6/23/2020 12:12:53 PM ******/ CREATE NONCLUSTERED INDEX [IX_EmployeeSwipes_Date] ON [dbo].[EmployeeSwipes] ( [Date] ASC ) INCLUDE ( [Id], [EmployeeId], [DeviceId], [Time], [Source], [ReaderType], [Action], [Badge], [ActivityCode]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'LastRebuildDate', @value=N'22/02/2019' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EmployeeSwipes', @level2type=N'INDEX',@level2name=N'IX_EmployeeSwipes_Date' GO /****** Object: Index [IX_ActivityExceptionRules_Code] Script Date: 6/23/2020 12:14:59 PM ******/ ALTER TABLE [dbo].[WorkActivityExceptionRules] DROP CONSTRAINT [IX_ActivityExceptionRules_Code] GO ALTER TABLE [dbo].[WorkActivityExceptionRules] ALTER COLUMN [Code] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL GO /****** Object: Index [IX_ActivityExceptionRules_Code] Script Date: 6/23/2020 12:14:59 PM ******/ ALTER TABLE [dbo].[WorkActivityExceptionRules] ADD CONSTRAINT [IX_ActivityExceptionRules_Code] UNIQUE NONCLUSTERED ( [Code] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO

← More in Software - TimeLOG Web / Synergy WF Still stuck? Contact support