Enable Page level Locking/Reorganize index task

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Enable Page level Locking/Reorganize index task

Author

Topic

mushy
Starting Member

12 Posts

Posted - 2010-01-08 : 15:47:18

Hi Guru's

we are planning to perform reorganize index task and MSDN says: reorganize fails if the table has one or more Indexes with ALLOW_PAGE_LOCKS set to OFF

when i run
SELECT * FROM sys.indexes WHERE allow_page_locks = 0
i get 13 rows (indexes) whose page level is locked.

I am unable to find the respective tables for these indexes. Can you please help in finding the tables with the help of sysindexes column info.

Thanks guys

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-08 : 15:50:38

[code]SELECT object_name(object_id), * FROM sys.indexes WHERE allow_page_locks = 0[/code]