gdev (paul.afamdi.okeke (AT) gmail (DOT) com) writes:
Quote:
I'm Trying to create a linked server from an SQL Server to another SQL
Server on another machine.
Can anyone suggest some good reference material or tutorials?? So far
I'm only finding examples for a linked server to an ACCESS database. |
There are plenty of examples in the topic for sp_addlinkedserver.
In many cases, it is as simple as:
exec sp_addlinkedserver THATSERVEROVERHERE
exec sp_serverioption THATSERVEROVERTHERE, 'data access', true
Authentication does not always work though, and in this case
sp_addlinkedsrvlogin comes to the rescue.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx