Database | Proc | Application | Created | Links |
sybsystemprocs | sp_monitor_trace_level | 31 Aug 14 | Defects 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 |