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.



Comments (3)

  1. CMcC says:

    Hi there,

    Looks like a very handy scriipt!

    Can you confirm that this is applicable for 2008 R2 as well?


  2. It should work fine with SQL Server 2008 R2.