Dropping database and table settings

To remove table or database lock promotion thresholds, use sp_dropglockpromote or sp_droprowlockpromote. When you drop a database’s lock promotion thresholds, tables that do not have lock promotion thresholds configured use the server-wide values.

When you drop a table’s lock promotion thresholds, Adaptive Server uses the database’s lock promotion thresholds, if they have been configured, or the server-wide values, if the lock promotion thresholds have not been configured. You cannot drop server-wide lock promotion thresholds.