Changing Query behavior based on local vs. remote context?
- From: "Keith" <keith@xxxxxxx>
- Date: Thu, 16 Aug 2007 09:20:10 -0700
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
.
- Follow-Ups:
- Re: Changing Query behavior based on local vs. remote context?
- From: Geoff N. Hiten
- Re: Changing Query behavior based on local vs. remote context?
- From: Andrew J. Kelly
- Re: Changing Query behavior based on local vs. remote context?
- Prev by Date: default schema (SQL Server 2005)
- Next by Date: Re: Changing Query behavior based on local vs. remote context?
- Previous by thread: default schema (SQL Server 2005)
- Next by thread: Re: Changing Query behavior based on local vs. remote context?
- Index(es):
Relevant Pages
|
|
