sp_dropglockpromote

Removes lock promotion values from a table or database.

sp_dropglockpromote {"database" | "table"}, objname

database | table: specifies whether to remove the lock promotion thresholds from a database or table. The quotes are required because these are Transact-SQL keywords.

objname: is the name of the table or database from which to remove the lock promotion thresholds.

Removes the lock promotion values from titles. Lock promotion for titles now uses the database or server-wide values:

sp_dropglockpromote "table", titles

Use sp_dropglockpromote to drop lock promotion values set with sp_setpglockpromote.
When you drop a database’s lock promotion thresholds, tables that do not have lock promotion thresholds configured will use the server-wide values.
When a table’s values are dropped, Adaptive Server uses the database’s lock promotion thresholds if they are configured or the server-wide values if they are not.
Server-wide values can be changed with sp_setpglockpromote, but cannot be dropped.

The permission checks for sp_dropglockpromote differ based on your granular permissions settings.

Granular permissions enabled	With granular permissions enabled, you must be a user with manage lock promotion threshold privilege.
Granular permissions disabled	With granular permissions disabled, you must be a user with sa_role.

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect