I just ran into this, and here's what I did to resolve it.  The server was a Windows 2000 server that got upgraded to Windows 2003.  However, not all of...

Thanks a bunch.  That's what my testing was showing, but I wanted to get a second opinion before I provided my research to my manager.

Laura

What's going on is the select statements are blocking the users.  Only repeatable read and serializable isolation levels will cause a shared lock to block an exclusive lock until the...

Thanks for your quick reply.  I've done the trouble shooting from the index/execution plan level. 

My main question is where can I find what transaction isolation level the customer is...

Are you setting the transaction isolation level to something other than read committed or read uncommited?  The default is read committed, which means that the SH is released when it's...