Post reply

Copying SPROCs from one node to another

  • September 8, 2006 at 8:44 am

    #62707

    We have set up a PC so that it can copy tables (using DTS) from my node in the SQL Server Group.  But for some reason it fails when the stored procedures are copied.  Do I need to adjust the privileges that I have set up for her on my node? 

  • September 8, 2006 at 9:52 am

    #659380

    Mark,

    Could you describe the DTS a little more?  Is the Import/Export Wizard used or has a DTS package been created?  Is the Copy SQL Server Objects task being used? 

    When you say "node" are you talking about SQL Server instances on different computer?

    Greg

    Greg

  • September 11, 2006 at 2:57 am

    #659578

    Is the Import/Export Wizard used or has a DTS package been created?

    ......  Import / Export Wizard

    Is the Copy SQL Server Objects task being used? 

    ...... Yes

    When you say "node" are you talking about SQL Server instances on different computer?

    ...... Yes

  • September 11, 2006 at 9:14 am

    #659680

    What happens when the import fails?  Any error messages?

    Greg

    Greg

  • September 11, 2006 at 9:35 am

    #659683

    I just tried to recreate the error message and have noticed that it is having a problem copying a table with a table name that begins with a number.  Why is that?

  • September 11, 2006 at 11:55 am

    #659736

    I don't know.  What specific error did you get for that?

    Greg

    Greg

  • September 12, 2006 at 5:05 am

    #659834

     

    I have now got a new error message that is the cause of SPROCS not transferring:

    'The login already has an account under a different user name.'

    It maybe because I tried to transfer the code through my machine and she has just moved off administrator right on her machine.

  • September 12, 2006 at 9:15 am

    #659917

    I think I can help with this one.  When you use the Import/Export wizard and choose to copy objects between SQL Server databases, you can set options for copying (uncheck "Use default options" & click on "Options" button).  I generally uncheck all the security options if the destination database already has users.  I think your latest error was caused by trying copy users and/or logins that already exist in the destination instance.

    Greg

    Greg

  • September 13, 2006 at 2:59 am

    #660024

    Now I get an error message saying that 'the login already has an account under a different user name'.

Viewing 9 posts - 1 through 8 (of 8 total)

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