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

Sounds like larger network packets are getting dropped. Some bridges that do not do packet splitting can cause this.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"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: how to know if query is processed in remote server
    ... One of the steps in execution plan shows "Remote Query". ... the data has been selected on remote server before it's pulled over to ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Possible?? SQL Svr obtaining data via SOAP/XML from another SQL Sv
    ... SQL servers (one local, one remote through the internet). ... I used VBScript, MSXML, MSSOAP to connect, query, parse and insert data into ... XML" functionality provided in SELECT verb. ...
    (microsoft.public.sqlserver.xml)
  • Re: Unwanted alphanumeric sort on time, incorrect min/max value
    ... query below is sorted on order and date ascending. ... Please show us the sql of the query being used to generate this data (you ... or a remote, linked table from ... table in Design mode and look at the data types (I'm not interested in the ...
    (microsoft.public.access.queries)
  • Re: Unwanted alphanumeric sort on time, incorrect min/max value
    ... query below is sorted on order and date ascending. ... Please show us the sql of the query being used to generate this data (you ... or a remote, linked table from ... table in Design mode and look at the data types (I'm not interested in the ...
    (microsoft.public.access.queries)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)