The sp_setrowlockpromote_ptn system procedure sets partition-lock promotion thresholds at the server, database, and table level.
sp_setrowlockpromote_ptn "server", null, new_lwm, new_hwm, new_pctThe syntax for setting the partition lock promotion threshold at the database or table level is:
sp_setrowlockpromote_ptn "database | table", objname, new_lwm, new_hwm, new_pct
sp_setrowlockpromote_ptn "server", NULL, 200, 300, 50
sp_setrowlockpromote_ptn "database", master, 1000, 1100, 45
sp_setrowlockpromote_ptn "table", "pubs2..titles", 500, 700, 10
Any user can execute sp_setrowlockpromote_ptn.