Database | Proc | Application | Created | Links |
sybsystemprocs | sp_aux_sys_encr_passwd_lookup | 31 Aug 14 | Defects Dependencies |
1 2 create procedure sp_aux_sys_encr_passwd_lookup 3 @db_name varchar(30) 4 as 5 begin 6 insert #sys_encr_passwd_info(dbname, typeofpasswd, modifier, moddate) 7 select @db_name 8 , case (object_info2) 9 when 0 then "persistent" 10 when 1 then "nonpersistent" 11 end 12 , object_cinfo 13 , convert(smalldatetime, convert(binary(4), object)) 14 from sysattributes 15 where class = 25 16 and attribute = 0 17 and object_type = "EC" 18 end 19
exec sp_procxmode 'sp_aux_sys_encr_passwd_lookup', 'AnyMode' go Grant Execute on sp_aux_sys_encr_passwd_lookup to public go
DEFECTS | |
MINU 4 Unique Index with nullable columns sybsystemprocs..sysattributes | sybsystemprocs..sysattributes |
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int | 15 |
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int | 16 |
MGTP 3 Grant to public sybsystemprocs..sp_aux_sys_encr_passwd_lookup | |
MGTP 3 Grant to public sybsystemprocs..sysattributes | |
MNER 3 No Error Check should check @@error after insert | 6 |
MUCO 3 Useless Code Useless Begin-End Pair | 5 |
MUCO 3 Useless Code Useless Brackets | 8 |
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysattributes.csysattributes unique clustered (class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo) Intersection: {class, object_type, attribute} | 15 |
MTR1 2 Metrics: Comments Ratio Comments: 0% | 2 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2 | 2 |
MTR3 2 Metrics: Query Complexity Complexity: 7 | 2 |
DEPENDENCIES |
PROCS AND TABLES USED writes table tempdb..#sys_encr_passwd_info (1) reads table sybsystemprocs..sysattributes |