SSMS question

SQL Ed

I am running a report in SQL SERVER 2008 that I inherited from a past co-worker in another state. The code is accessing two different servers, but SQl Server management studio seems to be only recongzing only one server/database/table at a time. Is it possible to access two servers while running one report in SSMS/ Below is the server names and databases:

ELMO.[HBS Patient Information].dbo.ECS_Plan_Information E (NoLock)
(Getting invalid oblect name when I hover over this)

[167.211.200.214].Billing03990.dbo.pclaim P

Ed English

Lost User

You can link[^] servers within SSMS. Once set up, you can query both servers in a single statement, by prefixing the server-name before the database-name.

Bastard Programmer from Hell :suss: