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


"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OeY8weE4HHA.3916@xxxxxxxxxxxxxxxxxxxxxxx
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:).

Unless you install the product on another machine and get the same behavior,
which I have.

Check the event logs and see if there are errors on that server.

The Event Viewer does not show any errors, nor does the error log in the
instance's data directory.

Considering that this behavior is present along with the installation of
this particular product, and that other named SQL and SQL Express instances
on the same machine do not demonstrate this behavior - even when returning
result sets orders of magnitude larger and on the same physical network -
I'm inclined to believe that this behavior is not machine specific but
rather localized to the named instance installed by this particular product.
Meaning, some configurable property of SQL Server.

I'm totally willing to believe that this is a bug in the product - a
misconfiguration of some kind - but it sounds like most folks don't think
that this type of (mis)configuration is even possible.

Oh, did I mention that this is a Microsoft product's install of SQL Express
;-)

k



.

Relevant Pages

  • Re: Under what circumstances would GetDate() return NULL?
    ... by replication, RDA, or another code path, I can't tell you why you ... We install that CAB so that we can get the messages from SQL errors, on some devices it seems to get deleted. ... These NULLs seem to also stem from errors in SqlCe itself, that is, an error occurs in executing a SQL query, thus a new record is inserted into our error log, but it cannot get the message for this error, so it just puts "Unable to parse SQLCE error. ...
    (microsoft.public.sqlserver.ce)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... http://www.clusterhelp.com - Cluster Training ... actually do the install to catch that one. ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)