Database | Proc | Application | Created | Links |
sybsystemprocs | sp_validaltlang | 31 Aug 14 | Defects Dependencies |
1 2 /* Sccsid = "%Z% generic/sproc/%M% %I% %G%" */ 3 /* 4.8 1.1 06/14/90 sproc/src/serveroption */ 4 5 create procedure sp_validaltlang 6 @name varchar(255) 7 as 8 9 10 if @@trancount = 0 11 begin 12 set chained off 13 end 14 15 set transaction isolation level 1 16 17 /* Check to see if this alias is in Syslanguages. */ 18 if exists (select * 19 from master.dbo.syslanguages 20 where alias = @name) 21 begin 22 return 0 23 end 24 return 1 25
exec sp_procxmode 'sp_validaltlang', 'AnyMode' go Grant Execute on sp_validaltlang to public go
DEFECTS | |
MINU 4 Unique Index with nullable columns master..syslanguages | master..syslanguages |
MGTP 3 Grant to public master..syslanguages | |
MGTP 3 Grant to public sybsystemprocs..sp_validaltlang | |
QISO 3 Set isolation level | 15 |
MSUB 2 Subquery Marker | 18 |
MTR1 2 Metrics: Comments Ratio Comments: 26% | 5 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 2dec - 2exi + 2 | 5 |
MTR3 2 Metrics: Query Complexity Complexity: 11 | 5 |
DEPENDENCIES |
PROCS AND TABLES USED reads table master..syslanguages (1) CALLERS called by proc sybsystemprocs..sp_setlangalias called by proc sybsystemprocs..sp_addlanguage |