Suppose that I have a database which name is
testdb in test server.
I also have a database named proddb in prod server.
Now I want to select data of a table of testdb database from proddb database.
How can I do that in
Also, I can do it using database link in oracle. But how can do that in SQL Server?