Database | Proc | Application | Created | Links |
sybsystemprocs | sp_ijdbc_getcatalogs | 31 Aug 14 | Defects Dependencies |
1 2 /* 3 ** sp_ijdbc_getcatalogs 4 */ 5 6 CREATE PROCEDURE sp_ijdbc_getcatalogs 7 as 8 9 if @@trancount = 0 10 begin 11 set chained off 12 end 13 14 delete #tmp_getcatalogs 15 16 set transaction isolation level 1 17 18 insert #tmp_getcatalogs 19 select name from master..sysdatabases order by name 20
exec sp_procxmode 'sp_ijdbc_getcatalogs', 'AnyMode' go Grant Execute on sp_ijdbc_getcatalogs to public go
DEFECTS | |
MGTP 3 Grant to public master..sysdatabases | |
MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_getcatalogs | |
MNER 3 No Error Check should check @@error after delete | 14 |
MNER 3 No Error Check should check @@error after insert | 18 |
QISO 3 Set isolation level | 16 |
MTR1 2 Metrics: Comments Ratio Comments: 5% | 6 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 | 6 |
MTR3 2 Metrics: Query Complexity Complexity: 10 | 6 |
DEPENDENCIES |
PROCS AND TABLES USED reads table master..sysdatabases (1) writes table tempdb..#tmp_getcatalogs (1) |