Removes lock promotion values from a table or database.
sp_dropglockpromote {"database" | "table"}, objname
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 use the server-wide values.
When a table’s values are dropped, the SAP ASE 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.
Setting | Description |
---|---|
Enabled | With granular permissions enabled, you must be a user with manage lock promotion threshold privilege. |
Disabled | With granular permissions disabled, you must be a user with sa_role. |
Values in event and extrainfo columns from the sysaudits table are:
Information | Values |
---|---|
Event | 38 |
Audit option | exec_procedure |
Command or access audited | Execution of a procedure |
Information in extrainfo |
|