Linked Server
It's quite a different area, which I would like to concentrate more. What's this???? linked server......
Accessing the resource in the other server can be achieved using Linked server. Considering am having a server named "ServerA" and I would like to grab some data from the remote server named "ServerB". In that case, we need to create a linked server. In our scenario, the linked server is "ServerB".
Let's see, How to link it? How to access the data?
Goto SSMS -> Your DB Server -> ServerObjects -> Linked Server - > Create new Linked Server.
You will get a message box to type your Linked server. You need to provide the servername.
Specify whether it's SQL Server or not. If it's not SQL Server, provide necessary details to connect it.
The second window is authentication, you need to specify the credentials used to access the Linked Server.
The third window specifies the options to be provided for the Linked server. If everything is good. Click "Ok" button.
Now, your Linked Server is created.
Now, you can see your catalogs listed under the Linked Server.
Now, am trying to access the Linked Server's table,
SELECT * FROM LinkedServer.VENKATDB.dbo.VENKAT_TABLE
Awesome,
Am able to see my data.