January 9, 2009 at 8:05 am
Hi there,
I am doing some testing & for the same,I am running queries using linked server.
When I run the query on the same server, I get resultset with X number of rows...but when I run the same query using linked server, I get few rows less..I couldn't figure out what could be the possible reason for it.
Btw, I am using MAX function in the sub query. In second case, I also get warning message:
"Warning: Null value is eliminated by an aggregate or other SET operation." However, i do not get such warning in first scenario.
Thanks
January 9, 2009 at 9:10 am
Need more info, what is the linked server (type of system), what query is being run, etc.
I saw some issues going against DB2 before where there was a limit in the driver on data set size being returned.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 9, 2009 at 9:31 am
All servers are SQL server 2005.
Data set isn't large.. 18000 rows approx.
I didn't get this:
what query is run?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply