Thanks, we're doing that anyway, but always worth a post here as well. I will post back if/when we get a solution from MS.
I believe we have the post-SP4 hotfix for AWE applied.
We had similar issues on SP3, but this KB article says that this is fixed in SP4. We still have the problem though. I found another post on this...
We have SQL Sever 2000 SP4 (32bit) running on and AMD 64bit server, and around every 2 weeks the server begins to fail and has to be rebooted. We...
A kludge it maybe, but it works. You're a genious. I hadn't even thought of using sysindexes. Seems it also works even for temp tables without an...
It seems you can get info for temp tables you create yourself in the same session, but not other people's (which I want I would like to do). USE...
Interesting, but still returns error 15009 when used on tables in tempdb.
I've tried something like:- select * from sysobjects where xtype = "U" exec sp_spaceused...
Is is possible to get the sizes and/or number of rows of tables in the tempdb? I can see them in sysobjects, but sp_spaceused returns error 15009...
Thanks Makes more sense than BOL, which leads you to believe it will only occur in a transaction (or at least a transaction your own doing)....
I've eventually traced one of the DELETE deadlocks using DBCC TRACEON. It's occuring when two DELETEs occur at the same time against the same table...
No, but I already had problem with parallelism on an UPDATE with a join before. MAXDOP sorted that one out. This one is just an ordinary UPDATE:-...
Interesting stuff. Only wish we had triggers on the tables in question, then I might have a solution. Have read some other posts which suggest...
Are you saying that a single UPDATE outside a transaction (not using any SPs) can cause a deadlock? In our case we know the exact statement which is...
Is it possible to get a deadlock outside transaction? We're occasionally getting them on UPDATEs & DELETEs. I've checked out loads of articles on...
To run a report in our 4GL system you must fire individual records/rows to a report function, usually using a FOREACH or WHILE loop and a cursor,...
We use a 4GL language with SQL 2000 SP3/ODBC. As an example we have a report program which uses a FOREACH cursor to process records and output them...
Some things to check or try:- If possible, run the query in READ UNCOMMITTED mode by issuing a SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED...
You may have a similar problem to me. I'm getting timeouts, though I can't see any bottlenecks or locks that could explain them. You could tell...
Disks also not particularly busy. % Disk Time & Avg Disk Queue Length are always same - something to do with Xeons or multiple disks. No visible...
Separate names with a comma.
