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.
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.
