Vincent (an**********@verizon.net) writes:
Is it possible to create a link server in SQL Server without using the
default system.mdw file? Any help is appreciated. Thanks.
Eh, yes. I don't even know what the system.mdw file might be.
Adding a linked server can be as easy as:
sp_addlinkedserver THATSERVEROVERTHERE
and then you might be able to say things like:
SELECT ... FROM THATSERVEROVERTHERE.db.dbo.tbl
It is not always that simple; this requires Windows authentication to
work all the way.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.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