Dropping Partition Lock Promotion Thresholds

The sp_ dropglockpromote_ptn and sp_droprowlockpromote_ptn system procedures remove partition-lock promotion thresholds at the server, database, and table level.

Related reference
sp_ dropglockpromote_ptn
sp_droprowlockpromote_ptn