Home Forums SQL Server 2005 Administering "..table "ItemNum" cannot be reorganized because page level locking is disabled" RE: "..table "ItemNum" cannot be reorganized because page level locking is disabled"
shashi kant
SSCommitted
Points: 1659
More actions
July 9, 2008 at 1:47 pm
#840485
Thanks Patrick Schneider
Nice solution for this problem and your Provide solution
ALTER INDEX index_name ON table_name SET (ALLOW_PAGE_LOCKS = ON)
is working fine in my case.
Thanks & Regards
Shashi Kant chauhan