SQL NET - A Place to talk on MS SQL Server and other database tools

Talks on SQL Server, database development, data management techniques,SQLBI/SSIS/SSAS/SSRS etc. Want to publish something db related ? mail to bineeshthomas@gmail.com with subject line starting as "SQLNET"

SQL NET FORUM

Portal Maintained By : BINEESH THOMAS

Wednesday, July 09, 2008

Simple way to add linked server

Adding

EXEC master.dbo.sp_addlinkedserver @server = N'AnyName',
@srvproduct=N'ServerName\Instance', @provider=N'SQLOLEDB', @datasrc=N'ServerName\Instance',
@catalog=N'DBNAME'

Executing

Select * from AnyName.DBNAME.dbo.TableName

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home

Free Domain Name - www.YOU.co.nr!