Database | Proc | Application | Created | Links |
sybsystemprocs | sp_monitor_enable_usage | 31 Aug 14 | Defects Dependencies |
1 2 /* 3 ** sp_monitor_enable_usage 4 ** 5 ** Generate help/usage information in terse/verbose mode. 6 { 7 */ 8 create procedure sp_monitor_enable_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 19270, @sqlmsg output 18 print @sqlmsg 19 exec sp_getmessage 19271, @sqlmsg output 20 print @sqlmsg 21 22 if (@output_type = 'terse') 23 begin 24 return 0 25 end 26 27 print " " 28 print " -- Enable monitoring for a specific type, to monitor statements." 29 print " sp_monitor enable, statement" 30 print " sp_monitor enable, 'statement monitoring'" 31 32 print " " 33 print " -- Enable monitoring for connection monitoring" 34 print " sp_monitor enable, connection" 35 print " sp_monitor enable, 'connection monitoring'" 36 37 print " " 38 print " -- Enable monitoring for all types" 39 print " sp_monitor enable" 40 print " sp_monitor enable, 'all'" 41 print " sp_monitor enable, 'all monitoring'" 42 43 return 0 44 45 end -- } 46
exec sp_procxmode 'sp_monitor_enable_usage', 'AnyMode' go Grant Execute on sp_monitor_enable_usage to public go
DEFECTS | |
MGTP 3 Grant to public sybsystemprocs..sp_monitor_enable_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: 24 | 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) |