Database | Proc | Application | Created | Links |
sybsystemprocs | sp_monitor_disable_usage | 31 Aug 14 | Defects Dependencies |
1 2 /* 3 ** sp_monitor_disable_usage 4 ** 5 ** Generate help/usage information in terse/verbose mode. 6 { 7 */ 8 create procedure sp_monitor_disable_usage( 9 @output_type varchar(10) 10 , @valid_type_names varchar(256) 11 ) as 12 begin 13 declare @sqlmsg varchar(256) 14 15 print " " 16 -- First generate terse messages. 17 exec sp_getmessage 19272, @sqlmsg output 18 print @sqlmsg 19 exec sp_getmessage 19273, @sqlmsg output 20 print @sqlmsg 21 22 if (@output_type = 'terse') 23 begin 24 return 0 25 end 26 27 print " " 28 print " -- Disable monitoring for a specific type, here for statements." 29 print " sp_monitor disable, statement" 30 31 print " " 32 print " -- Disable monitoring for deadlock events" 33 print " sp_monitor disable, deadlock" 34 print " sp_monitor disable, 'deadlock monitoring'" 35 36 print " " 37 print " -- Disable monitoring for all types" 38 print " sp_monitor disable" 39 print " sp_monitor disable, 'all'" 40 print " sp_monitor disable, 'all monitoring'" 41 42 return 0 43 44 end -- } 45
exec sp_procxmode 'sp_monitor_disable_usage', 'AnyMode' go Grant Execute on sp_monitor_disable_usage to public go
DEFECTS | |
MGTP 3 Grant to public sybsystemprocs..sp_monitor_disable_usage | |
MNER 3 No Error Check should check return value of exec | 17 |
MNER 3 No Error Check should check return value of exec | 19 |
MUCO 3 Useless Code Useless Brackets in create proc | 8 |
MUCO 3 Useless Code Useless Begin-End Pair | 12 |
MUCO 3 Useless Code Useless Brackets | 22 |
VUNU 3 Variable is not used @valid_type_names | 10 |
MTR1 2 Metrics: Comments Ratio Comments: 12% | 8 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 1dec - 2exi + 2 | 8 |
MTR3 2 Metrics: Query Complexity Complexity: 23 | 8 |
DEPENDENCIES |
PROCS AND TABLES USED calls proc sybsystemprocs..sp_getmessage reads table sybsystemprocs..sysusermessages reads table master..sysmessages (1) reads table master..syslanguages (1) calls proc sybsystemprocs..sp_validlang reads table master..syslanguages (1) |