Error in dbcc From Osql
From: dines (dines_at_discussions.microsoft.com)
Date: 11/20/04
- Next message: Fany Vargas [MSFT]: "RE: SQL Server Restore"
- Previous message: NT: "Re: Poor plan choice"
- Next in thread: dines: "Re: Error in dbcc From Osql"
- Maybe reply: dines: "Re: Error in dbcc From Osql"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 20 Nov 2004 00:59:01 -0800
Hi,
i get this error when i run Dbcc on one of my production server database
>From Osql Utility.
Msg 1934, Level 16, State 1, Server JorSRv3, Line 1
DBCC failed because the following SET options have incorrect settings:
'QUOTED_IDENTIFIER, ARITHABORT'.NULL
But when i run Dbcc from QA Utility i dont get any error and the Dbbc Gives
me CHECKDB found 0 allocation errors and 0 consistency errors in database I
tried to set
SET ARITHABORT Off
SET QUOTED_IDENTIFIER Off in my osql comand but still i get the same error
Thanks
- Next message: Fany Vargas [MSFT]: "RE: SQL Server Restore"
- Previous message: NT: "Re: Poor plan choice"
- Next in thread: dines: "Re: Error in dbcc From Osql"
- Maybe reply: dines: "Re: Error in dbcc From Osql"
- Messages sorted by: [ date ] [ thread ]