The blocking, the sid's, strange #'s for sid's... I recreated the db and all objects, repopulated, etc.... I suspect something was corrupt and I didn't put my finger on any...

Just wanted to say thanks.... the Blocking vs Locking.... you tipped me in the right direction here... and the system "seems" to be fixed. We'll see when the users get...

Hello. Blocking. I ran perfmon, physical counters seem in acceptable ranges. I did find during review today that I have some orphaned users though the server didn't overtly complain about...

Thank you. As far as I know this is not a global option on SQL Server 2000 but is specified at the query / connection level. Can you enlighten me...