>I have a remote view in the DE of a Form. When the form is opened and while it stays open, SQL Server keeps a Tabel Intent Lock on the table. This is sometimes causing lockups when another user tries to update.
>
>The remote view is a simple, one table, no where condition view, updatable, defined in the DBC.
>
>What is causing this lock to be maintained?
Hi,
You must be aware of the fact that SQL Server does Page Locking. If your table size is less then 2K, It locks the whole table evenif you'r selecting only one row out of it. There are several clauses which can be added with SELECT which affects the locking like HOLDLOCK etc. ( I don't rem. all of them). Look in detail for these clause in help/manual of SQL Server.
Bye
Jayesh
- Jayesh