This is a known bug with named pipes on SQL 2000 with MDAC2.8 and W2K3/Win2000.   If you are using these read this link.

http://support.microsoft.com/default.aspx?scid=kb;en-us;827452

you might also want to check, if your DSN is on the server, that it is configured as a System DSN rather than a User DSN, to ensure that the...

without knowing what the rest of the structure that the query reference is like, or what kind of data it holds, its a hard ask.

I can only assume that lnkey...

and here was me thinking a cursor was that thing that blinked at you in a word document.

Man you know some odd stuff..

Hear hear Remi.

Theres a number of good books on the subject, a good start is the list below. 

Thomas W Parsons - Introduction to Compiler Construction

Steven Muchnick - Advanced Compiler...

fear? looked it up in the dictionary.

seriously, its how a static compiler works.

rata,

no it is not fear, fear is a feeling of anxiety, apprehenion or agitation, usually due to the presence or imminence of danger or the imagined thought of.

There are...

SQL Server could perform the clustered index scan for the @x = -1 and then perform an index seek for C1 = @X, and then perform a union on the...

Okay, don't bother answering.  I eventually found my own answer to curiosity.

Instance Names apparently are limited to 16 characters, which doesn't follow the rules of a valid identifier.

Now the question...

Also if the K: is a cluster resource, use Cluster Administrator to ensure that the sql node is the current owner of the resource (if you are not familiar with Cluster...

Thank you, it took me a while to get it all nicely lined up .

I haven't used a GOTO since I last programmed my Commodore64 around...

A label is a valid identifier within TSQL, and thus a valid statement (albeit doesn't do much).

Due to the lack of encapsulation around the IF ELSE statements the...

Never mind, I managed to answer it myself.

After a little search, I found a reference to the extended sp xp_regread, and found a gem...

I would add a little something to Kay's suggestion.

Its not pretty, but I can find no better way of stripping the time off a datetime value, which could produce erroneous...