August 15, 2004 at 11:39 pm
I have one database that has just started causing my Integrity and Optimisation job to fail. The error generated is:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
I have turned Quoted_Identifier ON & also OFF and I still get this error. No other settings in the database have changed.
Does anyone know why when changing the Quoted_Identifier settings it seems to have no effect in getting the maintenance jobs to run? All other database on this server have no problems.
Thanks,
Angela
August 16, 2004 at 11:00 am
Do you have a computed column? This might apply:
http://support.microsoft.com/default.aspx?scid=kb;en-us;301292
August 29, 2004 at 10:24 pm
It turns out a Developer had added an index that included a computed column. There was no data in the table (and is unlikely there will be) and the developer was thinking the index may get used sometime in the future, so I just deleted the index and now everythings hunky dory.
Thanks,
Angela
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply