September 8, 2006 at 8:44 am
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
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
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
What happens when the import fails? Any error messages?
Greg
Greg
September 11, 2006 at 9:35 am
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
I don't know. What specific error did you get for that?
Greg
Greg
September 12, 2006 at 5:05 am
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
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
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