rwallacej
asked on
Copy data from remote database to local host
hi
I have data on a server and localhost. I want to copy data from remote server to local table. But there is issue when running
In SQL server management studio I have connected to both remote server and localhost
The table is called "tblPlanner"
Script I have to copy is
insert into dbo.tblPlanner (a,b,c)
Select a,b,c from
[myserver.mydomain.com].Da
when I run this I get error "Login failed for user forename.surname"
Help please, thank-you
I have data on a server and localhost. I want to copy data from remote server to local table. But there is issue when running
In SQL server management studio I have connected to both remote server and localhost
The table is called "tblPlanner"
Script I have to copy is
insert into dbo.tblPlanner (a,b,c)
Select a,b,c from
[myserver.mydomain.com].Da
when I run this I get error "Login failed for user forename.surname"
Help please, thank-you
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
The difference for SQL queries and SSMS/Copy DB Wizard is that the latter is executed at the client, while SQL is executed by the server.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
thanks for help
ASKER