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

OK then I would have to agree with Geoff in that it sounds like an issue with the servers communications. If you can run this fine locally and all other machines have issues it kind of narrows it down to that machine:). Check the event logs and see if there are errors on that server.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Keith" <keith@xxxxxxx> wrote in message news:e8xPg6C4HHA.5724@xxxxxxxxxxxxxxxxxxxxxxx
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: Excel "Web Query"
    ... write a macro to find a reliable source. ... .....I've been using Excel's "Web Query" for a while now but I've ... on "some" machines and not others. ... So, upon further investigation, it appears when you "Edit Web Query" ...
    (microsoft.public.excel)
  • Re: Excel "Web Query"
    ... .....I've been using Excel's "Web Query" for a while now but I've ... on "some" machines and not others. ... I know.....aren't pretty much ALL web queries used to do this :-) ... So, upon further investigation, it appears when you "Edit Web Query" ...
    (microsoft.public.excel)
  • Re: Design view (select query with link table issues)
    ... but they do not work on some user's machines? ... you try to open the table directly in the database window, ... you are talking about a query that draws from tables that are not ... >> permissions, Windows user permissions, or file-share permissions. ...
    (microsoft.public.access.queries)
  • Re: Union Query works on my PCs but not on clients machines
    ... will check all that out next time I visit the client. ... > To check the file versions between the two machines, ... The query contains undeclared parameters, ... >> office machines and updated it in the same way I updated my home PC. ...
    (microsoft.public.access.queries)
  • RE: ADAM AND ASP.NET
    ... > I configured 3 machines on the same domain ... > Windows 2000 Server ... > ADAM ... > From machine A I can successfully execute the following query to return ...
    (microsoft.public.windows.server.active_directory)