lsalih (2/15/2013)
When I go to linked server, I can see the system catalogs. Below is how I created the the linked server:EXEC sp_addlinkedserver
@server=N'Webdev',
@srvproduct=N'',
@provider=N'SQLNCLI',
@datasrc=N'DESTSERVR\INSTANCE';
The security is set to "Ba made using the login's current security context.
My account is set as admin to the server on both nodes.
Lava
Linked Servers are not in play when using OPENDATASOURCE. If you have a working Linked Server then maybe try this instead:
select *
from [DESTSERVR\INSTANCE].[TESTTBL].dbo.[TBLNAME]
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato