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 ?

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