Home > PASS Summit 2013, SQL Server > Update to Downgrading SQL Server Enterprise to Standard Scripts

Update to Downgrading SQL Server Enterprise to Standard Scripts

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.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: