asiaindian (2/26/2013)

---

1. Select statement : owner id=processc59288 is a 'SELECT ... FROM dbo.mtListPrice_view

' statement taking a shared lock on BASE table [dbo].[mtListPrice]

2. Insert statement on BASE table [dbo].[mtListPrice] is taking an exclusive X lock.

3. An X lock can be taken only when S or IS lock is released. This looks like a problem of conversion lock.

4. Do you have SNAPSHOT isolation on your DB?

hope this helps.