How to perform an INNER JOIN across different servers in SQL Server 2008?
Is it possible without using sp_addlinkedserver?
Asked
Active
Viewed 68 times
-1
-
1You can try `OPENROWSET` – Lukasz Szozda Sep 09 '15 at 15:54
-
Why would you not want to use linked servers? – Dan Bracuk Sep 09 '15 at 16:33
-
Permission not available to perform add linked server. That's why I was seeking other options. – Leo Sep 10 '15 at 05:29
1 Answers
0
I believe this may be your best option:
https://msdn.microsoft.com/en-CA/library/ms141775(v=sql.100).aspx
Fuzzy
- 3,760
- 2
- 14
- 32