Hello All,

My problem is that I want to allow page level locking for all the databases.


For one database, I am using below query:


sp_msforeachtable 'ALTER INDEX all ON ?
SET (
ALLOW_PAGE_LOCKS = ON
)
'

this enables page level locking for all indexes on all tables for one particular database.

How do I do it for all databases in one go.

I tried using sp_msforeachdb but realised I can't do it. I tried a couple of other things. but nothing worked.

Need help here!!!

Thanks in advance