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 the server-wide lock promotion thresholds.
