Link to home
Start Free TrialLog in
Avatar of wademi
wademi

asked on

How do I insert from one SQL server A to SQL server B.

I want to run a command like this:

insert into Server_A
(
  Select * from SERVER_B where id >140213
)


The name of ServerA is -  MEDS0010\MSDE_INSTANCE
And Server B  MEDSQL

The name of the database is on both servers are GIDE and the table JOB_EXT

I am currently running SQL enterprise manager from server A

I got these error messages:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
ASKER CERTIFIED SOLUTION
Avatar of randy_knight
randy_knight

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial