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

1     
2     /*
3     ** This stored procedure provides the ability to get the configuration number
4     ** for the given configuration parameter.
5     **
6     ** Parameters:
7     **      @cfgname	- configuration parameter name.
8     **
9     ** Returns:
10    **	config option number for the configuration parameter.
11    */
12    create procedure sp_monitor_getcfgnum @cfgname varchar(100),
13        @option_num int output
14    as
15    
16        select @option_num = config from master.dbo.sysconfigures
17        where name = @cfgname
18    
19        return (0)
20    

exec sp_procxmode 'sp_monitor_getcfgnum', 'AnyMode'
go

Grant Execute on sp_monitor_getcfgnum to public
go

DEFECTS
MINU 4 Unique Index with nullable columns master..sysconfigures	master..sysconfigures
MGTP 3 Grant to public master..sysconfigures
MGTP 3 Grant to public sybsystemprocs..sp_monitor_getcfgnum
MUCO 3 Useless Code Useless Brackets	19
QAFM 3 Var Assignment from potentially many rows	16
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysconfigures.csysconfigures unique clustered (name, parent, config) Intersection: {name}	17
MTR1 2 Metrics: Comments Ratio Comments: 51%	12
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2	12
MTR3 2 Metrics: Query Complexity Complexity: 5	12

DEPENDENCIES

PROCS AND TABLES USED reads table master..sysconfigures (1)   CALLERS called by proc sybsystemprocs..sp_monitor_enable   called by proc sybsystemprocs..sp_monitor_verify_setup      called by proc sybsystemprocs..sp_monitor_connection      called by proc sybsystemprocs..sp_monitor_statement      called by proc sybsystemprocs..sp_monitor_procedure      called by proc sybsystemprocs..sp_monitor_enable      called by proc sybsystemprocs..sp_monitor_list_montypes         called by proc sybsystemprocs..sp_monitor_list      called by proc sybsystemprocs..sp_monitor_archive         called by proc sybsystemprocs..sp_monitor_deadlock            called by proc sybsystemprocs..sp_monitor      called by proc sybsystemprocs..sp_monitor_disable      called by proc sybsystemprocs..sp_monitor_deadlock      called by proc sybsystemprocs..sp_monitor_event