You're welcome.

From Brent Ozar. Worth a read.

Stop Shrinking Your Database Files. Seriously. Now.

http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/

If you are going to shrink your database, at least put your NC indexes into a different filgroup...

http://ola.hallengren.com/

Friends don't let friends use Maintenance Plans.

(or Database Tuning Adviser, for that matter)

I agree with the above: http://ola.hallengren.com/

Very nice script.

I noticed that some of those ungodly long-named SharePoint databases were getting their names chopped off so I changed the variable and the #temp table column names...

Thanks, Mike. Glad to have been of help. I know 10% is not Best Practice, of course. But I had to have some value that was better than 1 MB,...

Yes, 10% is not good. Still, for a 10 to 100 GB database, 10% is a LOT better than the default of 1MB and as I said "Later you can...

I know 10% growth is a bad setting. That's why I said "Later you can go about tweaking them individually." The point is just to show you can run...

Good to know. Thanks!

Hey, Steve. Some of us aren't Christians, you know.

Happy Festivus!

Wonderful script, Cameron. Thanks!

I have to come up with an Auditing solution for data changes and you script helped me happily find out that most of my tables have...

Ouch! Recovery for SQL Server has gone up in price. It used to be only $159.

Sorry about that. Still, if you need it, you need it.

Hi,

I had the same trouble a few years ago and Recovery for SQL Server helped me.

If you don't mind spending a little money (it wasn't much) it's worth...

SQLSecurity.com get's my vote for best overall build list.

Oh. My mistake. I thought you meant between SQL 2005 and SQL 2008.

You should be able to do it from SQL Server 2005 to 2005, regardless of the OS....