DatabaseProcApplicationCreatedLinks
sybsystemprocssp_scan_xact  14 déc. 14Defects Propagation Dependencies

1     
2     create or replace procedure sp_scan_xact
3         @commid int = NULL
4     as
5         BEGIN
6             if @@trancount = 0
7             begin
8                 set transaction isolation level 1
9                 set chained off
10            end
11    
12            IF @commid = - 1 or @commid is NULL
13    
14                SELECT commid, start, lastchange, totnum, outnum,
15                    status, applname, xactname
16                FROM sybsystemdb.dbo.spt_committab
17            ELSE
18                SELECT commid, start, lastchange, totnum, outnum,
19                    status, applname, xactname
20                FROM sybsystemdb.dbo.spt_committab
21                WHERE @commid = commid
22        END
23    


exec sp_procxmode 'sp_scan_xact', 'AnyMode'
go

Grant Execute on sp_scan_xact to public
go
RESULT SETS
sp_scan_xact_rset_002
sp_scan_xact_rset_001

DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_scan_xact  
 MUCO 3 Useless Code Useless Begin-End Pair 5
 QCRS 3 Conditional Result Set 14
 QCRS 3 Conditional Result Set 18
 QISO 3 Set isolation level 8
 MRST 2 Result Set Marker 14
 MRST 2 Result Set Marker 18
 MTR1 2 Metrics: Comments Ratio Comments: 0% 2
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 5 = 4dec - 1exi + 2 2
 MTR3 2 Metrics: Query Complexity Complexity: 13 2

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_scan_xact_rset_002 
writes table sybsystemprocs..sp_scan_xact_rset_001 
reads table sybsystemdb..spt_committab (1)