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 |
|
hayko98
Starting Member
29 Posts |
 Posted - 2010-07-26 : 19:03:15
|
| Hi, We have 2 servers: PRD and DEV (PRD has 2 extra weeks of data).They are linked thru SQLNCLI Provider.This is my query: SELECT COUNT(*) FROM PRD_SERVER_name.PRD_DB_name.dbo.PRD_TABLE_name. When I connect to DEV Server and run this query, I am getting results of DEV_DB even though my query points to PRD Server. Anybody can explain why is this happening? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
hayko98
Starting Member
29 Posts |
Posted - 2010-07-26 : 19:35:51
|
| How do i fix this |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
hayko98
Starting Member
29 Posts |
Posted - 2010-07-26 : 19:44:26
|
| Thank You |
|
|
|
hayko98
Starting Member
29 Posts |
Posted - 2010-07-30 : 14:30:40
|
| Hi Tara,One of suggestions(by Erland Sommarskog) was drop and recreate linked server, which I did and did not get results that I was looking for. Then I decided to restart the DEV server .Then I dropped again and recreated new linked server. BINGO!!! It worked. Thanks for your time and affort |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Linked server query