This is exactly caused by an application. Two processes are performing conflicting updates in different orders and causing a deadlock. The best thing to do is run Profiler and track...

Can you map a drive/ping the IP from the web server? Sometimes there's some translation occurring.

Shared memory won't work. That's for local connections only.

Thanks for the update and good luck with that. Sounds like you're on the right track now.

Something else should have changed. This doesn't seem like a security issue, but more of a connection/ADO problem.

Apart from being poorly written.

If you run the query (parameters subbed) from Query...

I think one table is better, but you should be running Enterprise edition and perhaps looking at partitioned tables. Looks like one to your application, but the server handles the...

What's the statement?

Sorry to be late, but the MIME extension thing got us as well. W2K3 is more secure and doesn't allow a bunch of extensions like W2K does. For example, we...

Bob,

that made my night.

And don't forget just plain metal fatigue. When I was at Peoplesoft we saw the entire data center (including my office) drop power one afternoon. they were working on the...

Frank,

I think you have done the deletes the best way you can and it's what I've done in similar situations.

A few years ago at PASS we had a debate about...

I heard good things about the ApexSQL editor and the Quest Toad IDE, but never used them. I think Apex is a good bargain $$ wise.

I used the Embarkadero tools...

Yelena,

I've run into this as well with no solution. Rather than burn the call to PSS, I've just reset them to sa everytime I edit them. That's usually where the...

IF Profiler won't work, and you have some good reasons why it could be a pain, then you need to buy one of the log reader tools.

Red Gate Log Rescue

Lumigent...

That's an intersting question. No idea what will happen, but I'm guessing that it will break.

Good for you, but I'll take the sun and 2 weeks less vacation any day.