Possible to query all SQL Server Indexes which have page locks enabled? Is it possible to run a SQL Server Query in order to view all SQL Server Indexes which have page locks enabled?
SELECT OBJECT_SCHEMA_NAME(object_id) AS object_schema,
       OBJECT_NAME(object_id)        AS object_name,
       name                          AS index_name
FROM   sys.indexes
WHERE  allow_page_locks = 1