DatabaseProcApplicationCreatedLinks
sybsystemprocssp_aux_sys_encr_passwd_lookup  31 Aug 14Defects 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