Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eddiece
Starting Member
7 Posts |
 Posted - 2012-02-04 : 12:20:45
|
| 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 PEd English |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-04 : 12:39:01
|
| The hover-over is just intellisense and it's not that great. Run the query and see if it gives errors.--Gail ShawSQL Server MVP |
 |
|
|
eddiece
Starting Member
7 Posts |
Posted - 2012-02-04 : 13:25:49
|
| it ran for 7 hours before I stopped it.error says:Could not find server '167.211.200.214' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.Ed English |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-04 : 13:43:11
|
quote:
Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
And?Is that the correct name for the linked server that was created?--Gail ShawSQL Server MVP |
|
|
|
eddiece
Starting Member
7 Posts |
Posted - 2012-02-04 : 13:55:05
|
| It was the name provided to me. No one has answered my question yet. Should i be able to pull data from two different servers in one query in SSMS????Ed English |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-04 : 14:32:42
|
| It's got nothing whatsoever to do with SSMS. All SSMS does is submit a query to the SQL Server that you are connected to for processing. If the linked servers are set up correctly, then SQL will be able to connect to the other server and run the distributed query. If the linked server is not correctly set up, it will not.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
SSMS question