Users getting hourglassed and activity monitor shows blocking.
This was opened as another thread a month or so ago,
but that was closed when the problem sort of went away with not conclusive cause found.
Now after a month of so of not being a problem, it's back.
"In activity moniter, everytime there is a blocking situation, one of the threads involved with the blocking have
this query ( recid's vary)
UPDATE dbo.CAL SET COMPANY='20080919 13:06 20080919 12:57 20080922 09:24 20080922 10:36' WHERE RECID='7BEPPX1&2*>(JI9' AND COMPANY='20080919 13:06 20080919 12:57 20080922 09:24 20080922 10:35'
I have rebuild indexes for this table.
Both of these steps were taken previously:
Alter Database OurDatabaseName Set READ_COMMITTED_SNAPSHOT on
"SQL 2005 in compatibility mode for 2000 it should be ok. "
I'm thinking another clue may be found by setting up individual SQL logins to perhaps isolate which user(s) are involved. Then investigate their activity, or machine? But that's a long shot as I'm pretty sure their machines are all set up the same way.
Anyone else seen this before?