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

Yes...a dozen or so actually. And I've tried them on different remote
machines as well with SSMS and SSMSe, in addition to using queries from the
query window and "Open Table/View" from the Object Explorer.

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OTMOdYC4HHA.2312@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... that would give the users "live" access to the underlying queries. ... When selected from the drop-down list box, I what the the query that is ... 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
    ... 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)
Loading