Post reply

Problem With Copy SQL Server Objects Task

  • July 7, 2003 at 2:33 pm

    #151875

    I am trying to use the Copy SQL Server Objects Task in a DTS package to copy tables and SP's. It keeps failing saying that a particular SP already exists. I told it to drop and recreate all objects and since each SP name is unique (all are owned by dbo) I don't see why it is complaining. It should have dropped the existing SP and then made a copy of it. Has anyone seen this before?

    Robert W. Marda

    SQL Programmer

    bigdough.com

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

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • July 7, 2003 at 2:51 pm

    #464388

    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.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply