Viewing post 1 (of 1 total)
Page level locking can be set using the CREATE INDEX or ALTER INDEX statements :
ALTER INDEX index_name ON table_name SET (ALLOW_PAGE_LOCKS = ON)
The allow_page_locks column of sys.indexes view may help...
August 23, 2006 at 4:31 am
#656310