Database	Proc	Application	Created	Links
sybsystemprocs	sp_rjs_retrieve		31 Aug 14	Defects Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/%M% %I% %G% */
3     
4     /*
5     ** Messages for "sp_rjs_retrieve"
6     **   none
7     */
8     
9     create procedure sp_rjs_retrieve as
10        begin
11    
12            If @@trancount = 0
13                set chained off
14    
15            /* Don't do "Dirty Reads" */
16            set transaction isolation level 1
17    
18            /* Get the js rows in alpha order */
19            select js_server = object_cinfo,
20                host_name = char_value,
21                host_port = int_value
22            from master.dbo.sysattributes
23            where class = 22
24            order by object_cinfo
25    
26            return @@error
27        end
28    

Grant Execute on sp_rjs_retrieve to public
go

DEFECTS
MINU 4 Unique Index with nullable columns master..sysattributes	master..sysattributes
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int	23
MGTP 3 Grant to public master..sysattributes
MGTP 3 Grant to public sybsystemprocs..sp_rjs_retrieve
MUCO 3 Useless Code Useless Begin-End Pair	10
QISO 3 Set isolation level	16
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}	23
MRST 2 Result Set Marker	19
MTR1 2 Metrics: Comments Ratio Comments: 29%	9
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2	9
MTR3 2 Metrics: Query Complexity Complexity: 9	9

DEPENDENCIES

PROCS AND TABLES USED reads table master..sysattributes (1)