I believe you just "install" SQL 2000 and get the option to upgrade the existing version. I know if your OS support Enterprise, the products allow upgrades and installation of...

Great comments and some interesting points I hadn't thought of.

One thing I do like is giving employees a VM for their stuff if they need it. They could work at...

How are they running? If through SQL Agent, does that service account have permissions to do this?

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...