114 reputation
3
bio website decompiled.org
location Portland, ME
age 37
visits member for 2 years, 1 month
seen Aug 18 at 16:57

I'm boring. It's true.

@decompiledOne


Apr
11
awarded  Popular Question
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