Reindexing via maintenance plan

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

Reindexing via maintenance plan

Author

Topic

jauner
Starting Member

19 Posts

Posted - 2010-02-23 : 15:24:02

Why cant I do both update statistics and reogranize index pages in the maintenance plan? Also I getting the following error when doing the index via the maintenance plan:

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.

I am thinking I need to do a separate update statistics maintenance plan, which I assume should be done after the reorganize index pages plan.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-02-23 : 19:19:09

That error is why you shouldn't do reindex or reorganize via a maintenance plan. The maintenance plans aren't smart enough to check for the things required by ONLINE option. Use a custom script instead to avoid that error. Here's mine: http://weblogs.sqlteam.com/tarad/archive/2009/11/03/DefragmentingRebuilding-Indexes-in-SQL-Server-2005-and-2008Again.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

jauner
Starting Member

19 Posts

Posted - 2010-02-24 : 12:27:47

Thanks. The only problem is I am using SQL 2000

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources