We can't see the error. The box is too small.

How are you running through SSMS? Are you right-clicking an object in the Object Explorer and choosing execute or are you running the code directly in a query window?

We ran...

wodom (5/4/2010)

---

What would it matter how many bits our old version has anyway? I've also been asking what kinds of differences there might be between 32 and 64 bit...

Sorry, I misspoke. I don't run InputBuffer anymore. I have better code now that gives me the entire context of the command instead of just the first X number of...

wodom (5/4/2010)

---

I don't know. Haven't been able to find out. We're supposed to download it from MS....

It doesn't matter what database you're on for the InputBuffer command (and I believe the same for the OpenTran). A SPID is unique in the whole server instance. It should...

Another question. Are you querying directly through SSMS or through an application or web service?

Connection Timeout properties can hide all sorts of places and not all of them are...

tosscrosby (5/4/2010)

---

That's why I put the caveat in there about language nuances. I knew what you meant and I'm sure Brandie did too but a newcomer might not...

He's asking if your SQL 2000 is 64 bit or 32 bit.

I don't have experience with that version of Windows, but I think I heard that running 32 bit SQL...

Sorry, guys. I'm the one who called the WhiteCoats, but I thought they were going after my local...

There's a joke here I seem to...

Roust_m (5/3/2010)

---

This is the same. If you specify "norecovery"...

Sorry, Jason. I'm referring to Gianluca Sartori's post. I should have quoted him.

You can't rely just on writes, though. Excessive reads could also be causing an issue. Especially if there's a RBAR problem in the query. Bad use of indexing could also...

I'll hold you to that. @=)

It's a neat idea, and...