Joining tables in different databases instance and SQL servers

[dandalero]

Hi,

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_addlinkedser ver to add the server to sysservers."

Please advice

[ck9663]

Link the ims-gehanne server to your current server as the error said. Check the syntax of sp_addlinkedser ver in BOL.

Happy Coding!!!

~~ CK

[dandalero]

Thank you CK for your answer. It solved my problem.