DatabaseProcApplicationCreatedLinks
sybsystemprocssp_monitor_getcfgnum  14 déc. 14Defects Propagation 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 or replace 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    

DEFECTS
 MINU 4 Unique Index with nullable columns master..sysconfigures master..sysconfigures
 MGTP 3 Grant to public master..sysconfigures  
 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: 2 = 1dec - 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_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_procedure  
   called by proc sybsystemprocs..sp_monitor_list_montypes  
      called by proc sybsystemprocs..sp_monitor_list  
   called by proc sybsystemprocs..sp_monitor_event  
   called by proc sybsystemprocs..sp_monitor_enable  
   called by proc sybsystemprocs..sp_monitor_statement  
   called by proc sybsystemprocs..sp_monitor_connection