http://blogs.msdn.com/b/tommills/archive/2009/02/10/creating-a-job-to-re-index-all-user-databases-in-a-non-enterprise-edition-instance-of-sql-server-2005-2008.aspxHere'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 en-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/tommills/archive/2009/02/10/creating-a-job-to-re-index-all-user-databases-in-a-non-enterprise-edition-instance-of-sql-server-2005-2008.aspx#10299174Mon, 30 Apr 2012 16:45:45 GMT91d46819-8472-40ad-a661-2c78acb4018c:10299174Tom Mills Microsoft<p>It should work fine with SQL Server 2008 R2.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10299174" width="1" height="1">http://blogs.msdn.com/b/tommills/archive/2009/02/10/creating-a-job-to-re-index-all-user-databases-in-a-non-enterprise-edition-instance-of-sql-server-2005-2008.aspx#10299030Mon, 30 Apr 2012 10:15:05 GMT91d46819-8472-40ad-a661-2c78acb4018c:10299030CMcC<p>Hi there,</p> <p>Looks like a very handy scriipt!</p> <p>Can you confirm that this is applicable for 2008 R2 as well?</p> <p>Thanks</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10299030" width="1" height="1">http://blogs.msdn.com/b/tommills/archive/2009/02/10/creating-a-job-to-re-index-all-user-databases-in-a-non-enterprise-edition-instance-of-sql-server-2005-2008.aspx#9411508Wed, 11 Feb 2009 02:00:21 GMT91d46819-8472-40ad-a661-2c78acb4018c:9411508Creating a job to re-index all user databases in a Standard Edition instance of SQL Server 2005/2008 - Click &amp; Solve<p>PingBack from <a rel="nofollow" target="_new" href="http://www.clickandsolve.com/?p=6054">http://www.clickandsolve.com/?p=6054</a></p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9411508" width="1" height="1">