Executing the IN_DB_UPGRADE_SP_UPTIME_STEPS procedure to create the new filtered indexes without enabling the Quoted Identifiers option will result in not being able to create new documents.
Note: If this happens you will encounter errors in your application
server logs similar to the
following:
error (cat=54HT8B id=54MW2Y loc=38QGJ7 ref=EB6CF6): The database is reporting
an error. Contact your ImageNow administrator.
QUERY: INSERT INTO IN_INSTANCE_PROP(INSTANCE_ID, PROP_ID, IS_NULL, STRING_VAL, NUMBER_VAL,
TIME_VAL) VALUES(?, ?, ?, ?, ?, ?)
STATE: HY000
NATIVE CODE: 1934
MESSAGE: [ImageNow][ODBC SQL Server Wire Protocol driver][Microsoft SQL
Server]INSERT failed because the following SET options have incorrect settings:
'QUOTED_IDENTIFIER'.
Verify that SET options are correct for use with indexed views and/or
indexes on computed columns and/or filtered indexes and/or query notifications and/or
XML data type methods and/or spatial index operations.