network profile
| bio | website | decompiled.org |
|---|---|---|
| location | Portland, ME | |
| age | 36 | |
| visits | member for | 8 months |
| seen | Nov 16 '12 at 21:26 | |
| stats | profile views | 2 |
I'm boring. It's true.
|
Oct 23 |
comment |
Linked Server Query Results: OPENQUERY vs Distributed Transactions I cross posted this on StackOverflow. Here's what worked for me. stackoverflow.com/questions/13019624/… |
|
Oct 23 |
comment |
Linked Server Query Results: OPENQUERY vs Distributed Transactions @AaronBertrand what provider are you using on your linked server? Also, what settings do you have set on the Provider? I'm using SQLOLEDB with nothing checked on the provider properties screen. Thanks! |
|
Oct 22 |
comment |
Linked Server Query Results: OPENQUERY vs Distributed Transactions The first query works when the databases are on the same server. It does not work when they are linked. Query 2 works when they are linked. I'm curious as to why, what is the difference other than what server the query is run on. |
|
Oct 22 |
comment |
Linked Server Query Results: OPENQUERY vs Distributed Transactions I'm not sure if the issue is in the linked server configuration options or some instance level setting where the assignment to the parameter is only taking the last result when using four part naming referencing to a linked server. The sample code works perfectly when the server is not linked. |
|
Oct 22 |
comment |
Linked Server Query Results: OPENQUERY vs Distributed Transactions The results are returning as expected in the OPENQUERY. Not as expected in Four Part name. Setup is using SQLOLEDB. In general queries are working as expected, but not when assigning to a parameter. |
|
Oct 22 |
comment |
Linked Server Query Results: OPENQUERY vs Distributed Transactions @EricHiggins without the distributed transaction service configured the query would not run. Perhaps a configuration issue? |
|
Oct 22 |
comment |
Linked Server Query Results: OPENQUERY vs Distributed Transactions @AaronBertrand Both servers are 2008 R2. I did use PRINT to debug the string's that are getting generated and val + '' is indeed there. Using the samples above the first query returns 1 string and the bottom returns 3 if I do print val. Also, if I put the two databases on the same server and run sample 1 then three strings are returned. |
|
Oct 22 |
awarded | Student |
|
Oct 22 |
asked | Linked Server Query Results: OPENQUERY vs Distributed Transactions |
|
Oct 22 |
awarded | Autobiographer |
