We do not want to generate a line for databases that are already in simple recovery mode.  Add an 'OR' statement if you use bulk_logged
select 'alter database ['+name+'] set...

Dan, I have enjoyed this series greatly. Any plans for a step 8 to build the ssis packages to finish off the project? After you getting us this...

Thank you Anthony,

That was exactly what I was looking for. The developer was trying to just put the URL in the code the way you would on an intranet....

Hard lesson learned. Dont let anyone build a box for you to run SQL without checking their work. The Host server for this virtualized database server does not...

Hell, I dont want to support SQL2k at all much less different SPs! Force SP4 definitely. What could go wrong? 😀

I love when management wants an absolute...

I'm building out an Active/Active/Passive cluster but am not an expert. From what I've read on Technet you can install multiple instances of MSDTC but you dont have to....

Great! I'm now leaning heavily toward putting all of my old 80comp databases on SQL2k8 in compatibility mode 80. Any that will not work in that way will...

No, you can absolutely run in 80 compatibility mode on a 2005 box. I've done that many times and never had an issue. I'm pretty sure you can...

another concern I have would be that putting the 2000 database on a 2005 instance and some time passing before it was apparent that I had a problem and had...

Correct, but I have to allocate a set number of SQL Licenses and I would have used the remaining Licenses on 2005. If only some of them worked and...

I am going to SQL 2008 but not R2. I am putting together an Active-Active-Passive cluster and if I could have gotten 100% certainty I could have done 2005...

I'm over forty now and am much more efficient but not as fast. It reminds me of one of the stories in the book, "Seven habits of effective people"...

I have the same problem. I thought I'd wait for my maintenance window where I had to restart the SQL Service thereby recreating TempDB. It still has Active_transaction...

ok, more info I've found out....in the process of setting up a different domain account for one of the instances, SQL Agent for that instance would not restart. Investigating...

Awesome counter that I didnt know existed.. you guys rock!

Issue temporarily resolved. The cause is not known but restarting the instance stopped the problem. I’ll continue to monitor...