October 26, 2005 at 7:44 am
I have Two different Servers - both running SQL S2K Standard Edition. One is running sp3 and one is running sp3a
on both, I am running DB integrity checks via maintenance plans. on the Server running sp3, the integrity checks are failing with the following errror:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
I found a couple of KB articles about why this may be happening.. here's one..
http://support.microsoft.com/?kbid=902388
but I was just wondering if anyone else had ever experienced this and if anyone could explain to me why this is happening?? I'm thinking of applying sp3a and see if that fixes it... any ideas ?
October 27, 2005 at 3:36 am
SP3 is buggy, hence SP3a was released.
This problem is unrelated to whether it is SP3 or Sp3a
On one server you have "computed columns" and that is the issue, as per KB 902388 if you use sqlmaint.
To use KB 902388 fix you need SP4 anyway.
So apply SP4 and use this KB
or
Write your code and don't use sqlmaint.
Cheers
Shawn
October 27, 2005 at 10:35 am
Out of 25 servers and 400+ databases I have one that fits this criteria. It's not the DBCC that fails it's the Optimizatins for me. As for SP4, I'd be wary and do some research on this forum. There are quite a few 'documented' issues with SP4 here.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply