Bernadette
MIS
Can anybody tell me the main differences between a Remote Server and a Linked Server ?
Thank You In Advance
Bernadette B-)
Thank You In Advance
Bernadette B-)
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Remote and Linked Servers - Simple Question
- Thread starter Bernadette
- Start date
- Status
Right out of Books Online:
Remote server configurations have been superseded by linked server configurations in SQL Server version 7.0. Both stored procedures and distributed queries are allowed against linked servers; however, only stored procedures are allowed against remote servers. Support for remote servers is provided for backward compatibility only.
Robert Bradley
Do you have too much money? Visit
Remote server configurations have been superseded by linked server configurations in SQL Server version 7.0. Both stored procedures and distributed queries are allowed against linked servers; however, only stored procedures are allowed against remote servers. Support for remote servers is provided for backward compatibility only.
Robert Bradley
Do you have too much money? Visit
- Thread starter
- #3
Bernadette
MIS
Thank you very much for answering my question so quickly.
Bernadette
Bernadette
- Status