DatabaseProcApplicationCreatedLinks
sybsystemprocssp_monitor_trace_level  14 déc. 14Defects Propagation Dependencies

1     
2     /*
3     ** sp_monitor_trace_level
4     **
5     **	Utility procedure to return the current trace level from the control
6     **	table.
7     {
8     */
9     create or replace procedure sp_monitor_trace_level
10    as
11        begin
12            declare @trace int
13    
14            select @trace = configval
15            from tempdb.dbo.mon_config
16            where monitor = 'tracing'
17    
18            if (@trace IS NULL)
19                select @trace = 0
20    
21            return @trace
22        end -- }
23    

DEFECTS
 PERR 6 Parsing Error Could not find definition for table tempdb..mon_config 15
 MULT 4 Using literal database 'tempdb' tempdb..mon_config 15
 QTYP 4 Comparison type mismatch Comparison type mismatch: other vs varchar(7) 16
 MUCO 3 Useless Code Useless Begin-End Pair 11
 MUCO 3 Useless Code Useless Brackets 18
 MZMB 3 Zombie: use of non-existent object tempdb..mon_config 15
 MTR1 2 Metrics: Comments Ratio Comments: 23% 9
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2 9
 MTR3 2 Metrics: Query Complexity Complexity: 9 9

DEPENDENCIES
CALLERS
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_deadlock