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
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