Creating a job to re-index all user databases in a Standard Edition instance of SQL Server 2005/2008

  • 發行項

Here's another version of the reindex script that supports SQL Server 2005/2008 Standard and Workgroup Editions. It's got the online re-indexing code stripped out. If you're running something else like Workgroup, just change the code that checks for "Standard".

You can download the file attachment to get the script.

 

CreateReindexJobSQLStandard_BlogPost.sql

Comments

  • Anonymous
    February 10, 2009
    PingBack from http://www.clickandsolve.com/?p=6054

  • Anonymous
    April 29, 2012
    Hi there, Looks like a very handy scriipt! Can you confirm that this is applicable for 2008 R2 as well? Thanks

  • Anonymous
    April 30, 2012
    It should work fine with SQL Server 2008 R2.