Re: Changing Query behavior based on local vs. remote context?

My guess would be that there is a problem on the remote machine. Have you tried a 2nd remote query?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Keith" <keith@xxxxxxx> wrote in message news:%23Ej27KC4HHA.1824@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

I'm not sure if this is the right ng for this question, but here goes...

I just installed a product that uses SQL Express. When I run queries against the installed instance I get different behavior depending on if the query is run from Management Studio locally or from SSMS running on a remote machine. In both cases the user is a domain admin and the query is identical. The local query returns 1000+ rows, the remote query returns ZERO. If the query returns less than say 100 rows, there is no difference between remote and local.

Has anyone else seen this or use use/implemented it themselves?

I'm curious; how this behavior is defined/implemented? Is it database or instance specific? It seems to be instance-wide in my case but I'm not sure yet. I've been digging around in SSMS but haven't found any settings or properties that seem to apply to this, so any sugestions on where to look would be appreciated.

Thanks!

Keith


.

Relevant Pages

  • Re: Strange perf.
    ... HASH JOIN 72 6 K 132 ... REMOTE 30 K 2 M 72 CBDSRV_SRVCNS.WORLD SERIAL ... In the quick query the join is a hash join, ... will be executing about 30,000 queries ...
    (comp.databases.oracle.server)
  • Re: Strange perf.
    ... HASH JOIN 72 6 K 132 ... REMOTE 30 K 2 M 72 CBDSRV_SRVCNS.WORLD SERIAL ... In the quick query the join is a hash join, ... will be executing about 30,000 queries ...
    (comp.databases.oracle.server)
  • Re: Size of Query result
    ... update of my remote display has not always worked. ... But this problem that the query result cannot be set, ... button on a form that would refresh the links on the remote computer. ... Rolf Rosenquist wrote: ...
    (microsoft.public.access.queries)
  • ** query over db link behaving strange
    ... I have a query selecting from a local table and a view which selects ... The query is doing a full table scan at remote site ... This remote database is replicated. ... so it could have different statistics. ...
    (comp.databases.oracle.misc)
  • ** query over db link behaving strange
    ... I have a query selecting from a local table and a view which selects ... The query is doing a full table scan at remote site ... This remote database is replicated. ... so it could have different statistics. ...
    (comp.databases.oracle.server)