Rebuild index SP for TARA. - SQL Server Forums

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Rebuild index SP for TARA.

Author

Topic

SCHEMA
Posting Yak Master

192 Posts

Posted - 2009-07-31 : 14:17:14

Any updates?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-03 : 15:38:55

Have you checked her blog?

N 56°04'39.26"
E 12°55'05.63"

SCHEMA
Posting Yak Master

192 Posts

Posted - 2009-08-03 : 17:40:07

I have databases with 80 and 90 compatibility? I need the script which will take care in both compatibility.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-08-03 : 17:42:06

My script works fine for both compatibilities as long as you are using SQL Server 2005 or 2008. The script does not work in SQL Server 2000 since ALTER INDEX and the DMVs weren't available back then.

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."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-08-03 : 17:43:44

One other thing, make sure you install the stored procedure into a database that uses 90+ for the database compatibility level as it will error on creation if it is at 80. You then can call an 80 compatibility level database from isp_ALTER_INDEX.

Hope this is clear. You should not create the stored procedure in any of your application databases, but rather it should be created in a generic DBA database. We name ours either Admin or DBA. All of my scripts go in that database.

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."

SCHEMA
Posting Yak Master

192 Posts

Posted - 2009-08-03 : 19:40:58

Thanks Tara. Where Can I find you Latest SP that does that.

SCHEMA
Posting Yak Master

192 Posts

Posted - 2009-08-03 : 19:46:37

Is this the one?
http://weblogs.sqlteam.com/tarad/archive/2007/04/17/60176.aspx

Thanks Again.

SCHEMA
Posting Yak Master

192 Posts

Posted - 2009-08-03 : 20:21:32

I am getting Error:

The index "IDX" (partition 1) on table cannot be reorganized because page level locking is disabled.