-
Page level locking
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|