July 11, 2007 at 11:32 pm
I know this sounds stupid but I have got a bit confused in terms of linked servers and remote servers.
Can anyone tell me what exactly is a remote server.
A Linked Server is a Link to an external (remote) data source. The remote data source can be Oracle, Access, Excel or any other data source that uses an OLE DB provider.
Also A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers.
So what is a remote server..
July 11, 2007 at 11:46 pm
Remote servers were supported in SQL 2000 for backward compatability. They are not to be used. Always prefer linked servers to connect to other sql servers than remote servers. Remote servers were used in sql 7.0 and below versions.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply