Wow! So I have to schedule a short down time to stop and start SQL Server Service. Amazing. And it doesn't mention any of that in the documentation...

Which SQL service are you talking about?

As far as I can tell it's set up correctly.

Well so far no cigar... I pinged the server again and it worked fine. Then I telnetted into the smtp server on port 25 and that worked fine.

I have check...

Thanks for the hints; I really appreciate it. I just tried to ping the server and the request timed out. I'll have to see what that problem is and then try...

Thanks, all for your good advice. This is what I thought but just needed justification for my thoughts.

Thanks very much, Noel. All that makes sense; I just have to have a good reason to change an existing practice...

Happy coding,

Elizabeth

So, why wouldn't you ever shrink a database? If I'm changing a current maintenance plan, I'll need a logical reason for it since I'm the new person.

Elizabeth