Linked Server and Remote Server -- sql server clients

Cesar Kubo
12/30/2003 10:27:33 AM

When you use a SQL Server as a Linked Server you can run
transactions directly in a server, like this:
You have a Server A and Server B, you add Server B as
Linked Server in Server A, so, Server A can run TSQL
Statements directly into Server B.
Remote server is a Server that you can acesso from network

[quoted text, click to view]

Noorali Issani
12/30/2003 8:52:59 PM

Could you please explain what is the difference between Linked server and
remote server ..

I wanna remove all the remote server from my Server, how can I do ?

Any commands regarding this ...

Thanks in advance
Noor

cgross NO[at]SPAM online.microsoft.com
1/2/2004 10:20:39 PM

Basically, linked servers are newer technology than remote servers. Linked
servers have more options and more functionality.

Depending on what you are trying to do, you may be able to use the
workaround in this article to "switch" your remote servers to linked
servers:
274098 PRB: Adding a Linked Server Causes Error 15028
http://support.microsoft.com/?id=274098

Or, if you are not using replication, you can just go into Enterprise
Manager and delete the remote servers.

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : Linked Server and Remote Server