June 29, 2006 at 5:55 am
I found the following error in my maintenance plan please help me on this
Under maintenace plan history i found this error:-
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
and jobs failed with following error
i found this error in job history of optimization & integrity check jobs:-
Executed as user: XXXX\admin. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Please help me find out the solution
Thanks in advance
Regards,
Sumit
June 29, 2006 at 6:29 am
You probably have one or more indexed views or indexed computed columns in your DB - these require particular "set" options. Look in SQL Server books online to see what these are and how to set them.
In the meantime, from the top of my head, you can issue
sp_configure N'user options', 376
GO
RECONFIGURE WITH OVERRIDE
GO
This will change the default SET options for your server so that quoted identifiers are set for all connections as well as other ANSI defaults (null treatment, arithmetic overflows, etc). I personally like to have ANSI standards set but its not the default. You can also modify your SQL Server Agent series of steps to include the appropriate set statements ahead of the call to the extended stored proc to execute the maintenance plan.
Cheers
June 30, 2006 at 12:02 am
Hi,
Thanx for reply, i tried the same but it could not solve my problem..
Please help
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply