Thank you all for your thoughtful and informative replies. You've given me plenty of material to digest and suggestions to try on my process.

...

Imu92,

Thanks for the response. In answer to your question, I think my reason for restricting the size of the TEMPDB is based on at least two assumptions, none of which...

Elliot,

That did it! I'm not sure that I understand exactly how the UAC was causing problems but when I ran the application (or the command prompt) as Administrator, everything ran...

That is a good clue for me. The SQL code that was inserting data into the databas table was one long series of INSERT.... SELECT FROM with no GO separating...

So it makes sense to you that I would see an ALTER stored procedure hang up (and I mean hang up - I let it go for 4 minutes at...

Thank you all for your time and expertise. You've given me some things to think about and experiment with. Does anyone have any suggestions for additional reading that explores the...

In general, then, would it be fair to say that whenever you build an index on a table that doesn't yet have any indexex, first of all, you'll be adding...

I believe that there is a Command Line option. However, I have never used it since I've only used the product via the GUI up to now. If I remember...

Red Gate has a product that will do this very efficiently. It's called SQL Compare. Using this software, you compare your production database against an empty database and the product...