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 (3)

  1. CMcC says:

    Hi there,

    Looks like a very handy scriipt!

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

    Thanks

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