SQL Server Locks

 
Use sp_who and sp_who2  to identify which processes may be blocking other processes.
 
 
You can override how SQL Server performs locking on a table by using the SP_INDEXOPTION command. Below is an example of code you can run to tell SQL Server to use page locking, not row locks, for a specific table:
 
SP_INDEXOPTION 'table_name', 'AllowRowLocks', FALSE
GO
SP_INDEXOPTION 'table_name', 'AllowPageLocks', FALSE
GO

---

See how Windows Mobile brings your life together—at home, work, or on the go. See Now