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

1     
2     create 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

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: 4 = 3dec - 1exi + 2	2
MTR3 2 Metrics: Query Complexity Complexity: 13	2

DEPENDENCIES

PROCS AND TABLES USED reads table sybsystemdb..spt_committab (1)