Thanks Gail. I like that method.

Good to hear

Here's a blog with step by step on what you are trying to do.

http://blogs.msdn.com/b/bartd/archive/2006/09/13/751343.aspx

That's good to hear.

Follow the Moskva

We built this city

Script the tables and the data and run those in the 2005 server

Euthanasia

You can configure an unattended install and have all 50 install at about the same time.

Sounds like possibly a transaction rollback. Do any of your statements have a transaction declared and a rollback with them?

Please post responses to:

http://www.sqlservercentral.com/Forums/Topic1215131-147-1.aspx

Without having some sort of monitoring in place when the files grow like that, you won't be able to find out.

Check out this article for some ideas on how to...

It sounds like maybe an email antivirus scanner is stripping the root element. I would stick with the zip method as a permanent fix.

I have participated in penetration testing on occasion helping to penetrate and test security. It's fun and scary at the same time. Always take the findings and report...

One option is to use a central config file and have all of the clients use that central config for the app. Otherwise you will need to make a...