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 |
|
k886015
Starting Member
3 Posts |
 Posted - 2009-07-15 : 16:36:30
|
| I'm trying to execute a query looking at a test environment (server B) and comparing to a production environment (server A). this would save me hours of manual review in a separate application. Any ideas?Here is the query:select *from DSMNTSQL04.providers.dbo.fee_schedule_type pfst inner join DEVSQL01.providers.dbo.fee_schedule_type dfst onpfst.Fee_Schedule_Desc = dfst.Fee_Schedule_DescHere is my error message.Error: Could not find server 'DEVSQL01' 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. (State:37000, Native Code: 1C22)Error: Invalid cursor state (State:24000, Native Code: 0) |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2009-07-15 : 16:38:07
|
| Have you added the linked servers on your test server? Your query references two:DSMNTSQL04DEVSQL01Sounds like you're missing DEVSQL01 |
 |
|
|
|
|
|
sp_addlinkedserver