By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

Joining tables in different databases instance and SQL servers

P: 11

I'm joining tables from 2 different databases instance located on different SQL Server, I tried server.database.owner.table but I got the following error:

"Could not find server 'ims-gehanne' in sysservers. Execute sp_addlinkedserver to add the server to sysservers."

Please advice
Feb 11 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 2,878
Link the ims-gehanne server to your current server as the error said. Check the syntax of sp_addlinkedserver in BOL.

Happy Coding!!!

~~ CK
Feb 11 '10 #2

P: 11
Thank you CK for your answer. It solved my problem.
Feb 15 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.