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

1     
2     create procedure sp_localtypename(@sstype int)
3     as
4     
5         declare @curiso int
6         select @curiso = @@isolation
7         if @@isolation = 0
8         begin
9     
10            set transaction isolation level 1
11        end
12        select local_type_name from sybsystemprocs.dbo.spt_datatype_info where ss_dtype = @sstype
13    
14        if @curiso = 0
15        begin
16            set transaction isolation level 0
17        end
18        return (0)
19    

exec sp_procxmode 'sp_localtypename', 'AnyMode'
go

Grant Execute on sp_localtypename to public
go

DEFECTS
QTYP 4 Comparison type mismatch Comparison type mismatch: tinyint vs int	12
TNOI 4 Table with no index sybsystemprocs..spt_datatype_info	sybsystemprocs..spt_datatype_info
MGTP 3 Grant to public sybsystemprocs..sp_localtypename
MGTP 3 Grant to public sybsystemprocs..spt_datatype_info
MUCO 3 Useless Code Useless Brackets in create proc	2
MUCO 3 Useless Code Useless Brackets	18
QISO 3 Set isolation level	10
QISO 3 Set isolation level	16
MRST 2 Result Set Marker	12
MTR1 2 Metrics: Comments Ratio Comments: 0%	2
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2	2
MTR3 2 Metrics: Query Complexity Complexity: 13	2

DEPENDENCIES

PROCS AND TABLES USED reads table sybsystemprocs..spt_datatype_info