Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Joining two tables from different servers

Author  Topic 

SQLBoy14
Yak Posting Veteran

70 Posts

Posted - 2014-08-12 : 23:30:52
Hi Sql expert,

I am joining two tables from two different servers but getting an error "can not find the server in sys.server"

What and how do solve this server error? Anyone can help? Do I need to do setting between those two servers so they can connect?

Thank you

SQLBoy

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-08-13 : 03:05:22
Please post your query
Go to Top of Page

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2014-08-13 : 18:49:44
Are you expecting a linked server to exist for the remote server? Does it exist?



Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy
Go to Top of Page
   

- Advertisement -