Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2009-01-12 : 23:08:57
|
| Hi Experts,Can anyone help me in how to overcome this error while setup Reindex on SQL Server 2005 Version through Maintenance plans.When Parsing the Query there is no error however, while executing the following error appears.Executed as user: NT AUTHORITY\SYSTEM. ALTER INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. [SQLSTATE 42000] (Error 1934). The step failed.Advance Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-12 : 23:18:48
|
| See this: 1)http://support.microsoft.com/kb/902388 2)http://support.microsoft.com/kb/301292/ |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-01-12 : 23:49:19
|
| Thanks Sodeep.This problem relates to Maintenance plan while Reindex script is scheduled in the SQL Server Agent Job.Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. The Article http://support.microsoft.com/kb/902388good for ArithAbort related problems and QuotedIdentifier but never deals with what is to be done with above Highlighted portion - above.The Reindex Script when executed on T-SQL is absolutely fine but not when put in the Agent Job giving the error as highlighted in bold.Can you help in deducing this Please.Many Thanks in Advance. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-13 : 00:13:46
|
| Asked here:http://www.sqlservercentral.com/Forums/Topic473503-146-1.aspx |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-01-15 : 18:29:17
|
| Thanks So Deep |
|
|
|
|
|
|
Reindex on 2005 Server