in win32 with MSSQL I use critical sections to ensure no two threads talk to the database at the same time on the same connection.  Without this I get hsmt busy...

Never mind, changed my search and found some scripts that showed how using sp_who and kill. Worked great.

Thank you very much for the all that information. Now time to experiment!

Jim kane

[For the updates, perhaps a snapshot replication model for certain tables might be the best here.]

Steve:

Thanks for the reply. The MSDE instances will not have connection to the...

How many processors are you all running?

Is this something that can only happen on a multiple CPU machine?