Archive for October 24, 2013

Update to Downgrading SQL Server Enterprise to Standard Scripts

October 24, 2013 Leave a comment

It's hard to believe that I wrote this post almost a year ago. It's been my most popular post, so I wanted to let people know about a change to one of the scripts. Many thanks to reader Francesco for pointing out an error. The Attach Script uses sp_msforeachdb and in the original script, I failed to wrap the ? wildcard in square brackets. As a result, database names containing dashes (I'm looking at you SharePoint), would not resolve properly. The script has been updated.

Having seen Kevin Kline (b|t) and Aaron Bertrand (b|t) present 10 Query Tuning Techniques Every SQL Programmer Should Know at this year's PASS Summit, I know I should update the code to use Aaron's sp_foreachdb. I will put that on the list of things to learn. That is why I love this job, because there is always something new to learn.