Database	Proc	Application	Created	Links
sybsystemprocs	sp_setrowlockpromote		31 Aug 14	Defects Dependencies

1     
2     /* Stored procedure for adding or modifying lock promotion attribute. 
3     ** Database attributes can only be modified when using Master.
4     */
5     
6     /*
7     ** Messages for "sp_setrowlockpromote"
8     **
9     ** 17260, "Can't run %1! from within a transaction."
10    ** 17421, "No such database -- run sp_helpdb to list databases."
11    ** 17460, "Object must be in the current database."
12    ** 18090, "The target object does not exist."
13    ** 18158, "At least one of the parameters 'new_lwm', 'new_hwm' or 'new_pct' must be non-NULL to execute this procedure."
14    ** 18159, "You must be in the 'master' database to add, change or drop lock promotion attribute for a user database."
15    ** 18160, "Please specify a non-NULL value for %1, since it has not been set previously with a non-NULL value."
16    ** 18161, "Object name parameter must be NULL for Server-wide lock promotion attributes. Using NULL instead of - %1."
17    ** 18162, "'%1!' is a not a user table.  '%1' can be used only on user tables."
18    ** 18163, "The lock promotion LWM value %1 cannot be greater than the lock promotion HWM value %2."
19    ** 18164, "Invalid value specified for 'scope' parameter. Valid values are 'SERVER','DATABASE' or 'TABLE'."
20    ** 18165, "The 'lock promotion!' attributes of %1 '%2' have been changed. The new values are %3."
21    ** 18338, "Invalid obj_type parameter: '%1!'. Please specify 'PAGE' or 'ROW'."
22    */
23    
24    create procedure sp_setrowlockpromote
25        @scope varchar(10), /* table, database or server */
26        @objname varchar(767) = NULL, /* table or database name */
27        @new_lwm int = NULL, /* Lock promotion lwm value */
28        @new_hwm int = NULL, /* Lock promotion hwm value */
29        @new_pct int = NULL /* Lock promotion pct value */
30    as
31    
32        declare @status int
33    
34        exec @status = sp_setlockpromote "ROW", @scope, @objname,
35            @new_lwm, @new_hwm, @new_pct
36        return (@status)
37    

exec sp_procxmode 'sp_setrowlockpromote', 'AnyMode'
go

Grant Execute on sp_setrowlockpromote to public
go

DEFECTS
MGTP 3 Grant to public sybsystemprocs..sp_setrowlockpromote
MNER 3 No Error Check should check return value of exec	34
MUCO 3 Useless Code Useless Brackets	36
MTR1 2 Metrics: Comments Ratio Comments: 82%	24
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2	24
MTR3 2 Metrics: Query Complexity Complexity: 4	24

DEPENDENCIES

PROCS AND TABLES USED calls proc sybsystemprocs..sp_setlockpromote      read_writes table sybsystemprocs..sysattributes      reads table master..sysdatabases (1)      calls proc sybsystemprocs..sp_configure         read_writes table tempdb..#optlevel (1)        reads table master..spt_values (1)         reads table master..syscurconfigs (1)         reads table master..syscharsets (1)         reads table master..sysconfigures (1)         reads table master..syslanguages (1)         calls proc sybsystemprocs..sp_autoformat            reads table master..systypes (1)            calls proc sybsystemprocs..sp_namecrack            calls proc sybsystemprocs..sp_autoformat            reads table master..syscolumns (1)            reads table tempdb..systypes (1)            read_writes table tempdb..#colinfo_af (1)           reads table tempdb..syscolumns (1)         writes table tempdb..#temptable1 (1)        calls proc sybsystemprocs..sp_configure         writes table tempdb..#temptab (1)        calls proc sybsystemprocs..sp_aux_getsize         reads table master..sysattributes (1)         writes table tempdb..#temptable (1)        read_writes table tempdb..#configure_temp (1)        writes table tempdb..#temptable3 (1)        calls proc sybsystemprocs..sp_getmessage            reads table master..sysmessages (1)            reads table sybsystemprocs..sysusermessages            reads table master..syslanguages (1)            calls proc sybsystemprocs..sp_validlang               reads table master..syslanguages (1)         reads table master..sysdevices (1)      reads table sybsystemprocs..sysobjects      calls proc sybsystemprocs..sp_getmessage      reads table master..sysconfigures (1)