Forgive me for answering my own question, but I just found the answer and will post it here in case someone else runs into the same problem.

There was an SP in the source database that was renamed in Enterprise Manager but the name of the SP was still the original name when you edit the SP. So, this task generated two drop and two create commands with the name it found inside the SP and ran all the drop commands first and then the create commands.

I hope that is clear enough.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.