Posted by Erland Sommarskog on 02/19/07 23:25

Vincent (animedreamer@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]