Select * from ADIL.B.DBO.User is incorrect if you are trying to connect to
the B database. ADIL is not the name of the linked server.

Try using this select "Select * from Basha.B.DBO.User" if you are running
from system Adil. The server name in the select needs to be the name of the
Linked Server. LS.Database.owner.Table. In this case Basha looks like the
name of the LS. But you may also be backwards with the linked server. You
may want to put the insert and the linked server on system B to go to system
A. Because right now you are inserting into database A and grabbing from B,
which you stated to go from A to B.

Also, another way to verify if an LS can see the other server, is to go into
EM and select the linked server and see if the other tables from the other
database appear.

-Stephen



-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] Friday, November 22, 2002 4:39 AM
To: LazyDBA.com Discussion
Subject: Transfer of data Urgent


Hi,
We r developing a vb tool to transfer data from one
data base to another data base(all together
different system)
In detail
I have 2 database A and B. A DB is in system Adil and
B database is in System basha
and both the DB have the same tables i want to
transfer data of 3 tables from A DB of system Adil to
B DB of system Basha
i Ran this SP In A DB in Adil

sp_addlinkedserver @server='Basha', @srvproduct='',
@provider='SQLOLEDB',
@datasrc='B'
(1 row(s) affected)


(1 row(s) affected)

Stored Procedure: A.dbo.sp_addlinkedserver
Return Code = 0



but when i run the insert statement

Insert into User
Select * from ADIL.B.DBO.User

Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.

pls help me in solving this.

TIA
ADIL

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page