Viewing 15 posts - 32,746 through 32,760 (of 39,740 total)
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...
December 15, 2006 at 1:04 pm
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.
December 15, 2006 at 1:01 pm
Thanks for the update and good luck with that. Sounds like you're on the right track now.
December 15, 2006 at 7:17 am
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...
December 14, 2006 at 7:44 am
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...
December 14, 2006 at 6:46 am
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...
December 11, 2006 at 9:48 pm
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...
December 11, 2006 at 9:41 pm
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...
December 11, 2006 at 9:43 am
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...
December 11, 2006 at 8:48 am
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...
December 11, 2006 at 8:47 am
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...
December 11, 2006 at 8:46 am
That's an intersting question. No idea what will happen, but I'm guessing that it will break.
December 11, 2006 at 8:43 am
Good for you, but I'll take the sun and 2 weeks less vacation any day.
December 11, 2006 at 8:40 am
Viewing 15 posts - 32,746 through 32,760 (of 39,740 total)