Quoted Identifier Setting

taustin · Post by **taustin** » Wed Jul 27, 2005 7:26 am

After upgrading to 3.1 last week, we noticed that our DB reindex / reorg job started failing for the Vault database. The error message is:

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.

The database properties have the quoted identifier setting checked. Should this be off for the job to run? Will changing this setting affect the Vault service or client? Any suggestions?

lbauer · Post by **lbauer** » Wed Jul 27, 2005 7:36 am

Vault uses a computed column within an index, which can cause SQL Server Enterprise Manager Optimization plans to fail. Enterprise Manager's extended stored procedure is configured with an incorrect initial environment, which does not allow it to run the optimization commands on any database containing computed columns within an index.

Similar issue here:
http://support.sourcegear.com/viewtopic.php?t=3424

We have a set of recommendations here for Vault maintenance that works with our database schema:

http://support.sourcegear.com/viewtopic.php?t=2924

taustin · Post by **taustin** » Wed Jul 27, 2005 8:02 am

Thanks Linda!

I think I remember seeing that come through the forums now that you mention it. I probably should have searched more carefully...