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 |
|
JohnLee80
Starting Member
3 Posts |
 Posted - 2010-07-04 : 22:33:11
|
| Is there any alternative solution in using Linked Server other than OPENQUERY.Regards,John |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-07-05 : 13:13:24
|
| If you have a linked server set up - you can use 4-part naming to access the linked server.Example: SELECT ... FROM linkedserver.database.schema.object; |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-07-07 : 12:49:33
|
| we are using a report on report (local and/or reporting services report) to bypass the linked server issue and double hop issues for a web UI. We are using the report as a data source via xml serialization.<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-07 : 13:35:01
|
| "Is there any alternative solution in using Linked Server other than OPENQUERY."What problem do you have with OPENQUERY that you want to solve?We have found OPENQUERY suits us the best of the various approaches we have tried. |
|
|
|
JohnLee80
Starting Member
3 Posts |
Posted - 2010-07-07 : 21:17:26
|
quote:
Originally posted by Kristen
"Is there any alternative solution in using Linked Server other than OPENQUERY."What problem do you have with OPENQUERY that you want to solve?We have found OPENQUERY suits us the best of the various approaches we have tried.
We have used the OPENQUERY in many Stored Procedure. So it takes more time to execute. We want to purge the OPENQUERY to reduce the exection time.Regards,John |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-08 : 03:26:17
|
| We hold a local copy of the remote data. No good if you want real-time access to remote data, but if "last night's version" is good enough that might do you.(You could use replication to get the data locally, but that will transfer all changes of course. We transfer only records that have changed materially since "last time")But if you want to query remote data then ... errmm ... it will take as along as it takes! If you have inefficient queries then you can optimise them, but OPENQUERY isn't inherently slow. |
|
|
|
|
|
|
How to Link two Server?