Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dagsson
Starting Member
1 Post |
 Posted - 2006-06-14 : 03:17:22
|
| Hi,Im experiencing a strange lock in a SQL Server 2000, where Navision runs on top of it.It seems that a query locks a single record in a table, for example a customer with a customer_id, that results in that other users are unable to select from it. I have tried sp_who and different tools but havent been successful in tracing the query that makes the lock.Now the bizarre thing is that if I change a property on the database, ie. any property, the lock dissappears. I change the database to not update statistics and the record is again available.Does anyone have an idea. |
|
|
sqldev80
Yak Posting Veteran
68 Posts |
Posted - 2006-06-15 : 12:33:47
|
| what kind of isolation lever are u using. is it row level?? |
 |
|
|
|
|
|
Strange lock issue