DatabaseProcApplicationCreatedLinks
sybsystemprocssp_monitor_trace_level  31 Aug 14Defects 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 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    


exec sp_procxmode 'sp_monitor_trace_level', 'AnyMode'
go

Grant Execute on sp_monitor_trace_level to public
go
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
 MGTP 3 Grant to public sybsystemprocs..sp_monitor_trace_level  
 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: 2 = 1dec - 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