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: Unable to install 64bit SQL 2005 on Windows 2008 Cluster
    ... cluster installation of SQL. ... All of the database files are on the SAN share. ... Below are the logs from the install. ... SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • 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)