ALTER INDEX < Index name >  ON   < Table Name >
SET (
    ALLOW_PAGE_LOCKS = ON
)
GO

这将起作用

This will work