Prev: xp_cmdshell sql server 2000
Next: Reading a directory
From: Vincent on 18 Feb 2007 22:41
Is it possible to create a link server in SQL Server without using the
default system.mdw file? Any help is appreciated. Thanks.

From: Erland Sommarskog on 19 Feb 2007 18:25
Vincent (animedreamer(a)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(a)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
 | 
Pages: 1
Prev: xp_cmdshell sql server 2000
Next: Reading a directory