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
MS Sql Server LazyDBA home page