When upgrading the Database via the installer you will see the error below.
Database Creation Successful - Database Migration Failed (See below)
Details:
Attempting to load SQL Script file - C:\Program Files\Quest Software\MessageStats\SQL\MessageStatsMigration.sql
SQL Script File Successfully Loaded
Attempting to Migrate Application Specific Database Objects
ERROR OCCURRED DURING DATABASE OBJECT MIGRATION WHILE EXECUTING THE FOLLOWING:
IF not exists (select * FROM syscolumns inner join sysobjects on sysobjects.id = syscolumns.id
where sysobjects.name = 'T_MailboxMsgDetailsSent' AND syscolumns.name = 'DateWithoutTime')
BEGIN
ALTER TABLE dbo.T_MailboxMsgDetailsSent ADD
DateWithoutTime AS CONVERT(DATETIME, CONVERT(NVARCHAR, [Date], 112), 112) PERSISTED
END
THE ERROR DESCRIPTION IS:
ALTER TABLE failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center