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: Query In BE database
    ... What Is A Remote Query? ... point your local query to a query that was in another Access database. ... queries and that is remote queries. ...
    (microsoft.public.access.queries)
  • 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: Query In BE database
    ... In the table is a list of all the queries that are available to be selected. ... When selected from the drop-down list box, I what the the query that is being ... What Is A Remote Query? ... point your local query to a query that was in another Access database. ...
    (microsoft.public.access.queries)
  • Re: Query In BE database
    ... As additional queries are requested I ... All I would do is create the query, name it, and add the query name ... What Is A Remote Query? ... point your local query to a query that was in another Access database. ...
    (microsoft.public.access.queries)