Thanks Prett. I'm glad that my understanding of this aligns with the experts.

I now have the backup I need to take to the networking team.

Thanks Steve. Much appreciated.

Thanks Gail. I appreciate hearing from your experience on this.

All of our SQL Servers are on VMs except one. That one will be moved over to a VM this year and the box retired.

Hi Tim,

I added a check to your code to skip off-line databases. Here is the original section of code:

--Begin our maintenance tasks.

DECLARE curDatabase CURSOR FOR

--This statement filters out system databases...

Thanks Howard. I should have thought of that. Appreciate the help.

Thanks all. I know it's not useful for anything other than a teaching tool. I was hoping to get to the execution of the dynamic SQL mess at the end...