This is a mirror of official site: http://jasper-net.blogspot.com/

Linked Server Concept in SQL Server

| Monday, September 13, 2010
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.

1.gif

Read more: C# Corner

Posted via email from .NET Info

0 comments: