Refrence of the Other Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Refrence of the Other Server


How wil i use the reference of the other server in job
like
select distinct id from servername.db.dbo.tablename
its giving me the sysntax error

You need to add other server as Linked server. Read about it in sql server help file Madhivanan Failing to plan is Planning to fail
Alas i m not getting the actual topic in sql server help
could u plz give me the topic name

‘linked servers’
Also refer sp_addLinkedServer Madhivanan Failing to plan is Planning to fail
… refer help file means look at the books online that will be installed alongwith SQL Server installation. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
By the way, what is the syntax error? Nathan H. Omukwenyi
MVP [SQL Server]

]]>