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

1     
2     /* Sccsid = "%Z% generic/sproc/src/%M% %I% %G%" */
3     /*	4.8	1.1	06/14/90	sproc/src/serveroption */
4     create procedure sp_validlang
5         @name varchar(255)
6     as
7     
8     
9         if @@trancount = 0
10        begin
11            set chained off
12        end
13    
14        set transaction isolation level 1
15    
16        /* Check to see if this language is in Syslanguages. */
17        if exists (select *
18                from master.dbo.syslanguages
19                where name = @name)
20        begin
21            return 0
22        end
23        return 1
24    

exec sp_procxmode 'sp_validlang', 'AnyMode'
go

Grant Execute on sp_validlang 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_validlang
QISO 3 Set isolation level	14
MSUB 2 Subquery Marker	17
MTR1 2 Metrics: Comments Ratio Comments: 28%	4
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 2dec - 2exi + 2	4
MTR3 2 Metrics: Query Complexity Complexity: 11	4

DEPENDENCIES

PROCS AND TABLES USED reads table master..syslanguages (1)   CALLERS called by proc sybsystemprocs..sp_setlangalias   called by proc sybsystemprocs..sp_addmessage   called by proc sybsystemprocs..sp_addlanguage   called by proc sybsystemprocs..sp_getmessage      called by proc sybsystemprocs..sp_help_qpgroup      called by proc sybsystemprocs..sp_setrepcol      called by proc sybsystemprocs..sp_spaceusage_showhelp_display         called by proc sybsystemprocs..sp_spaceusage_showhelp_all            called by proc sybsystemprocs..sp_spaceusage_showhelp               called by proc sybsystemprocs..sp_spaceusage      called by proc sybsystemprocs..sp_dropthreshold      called by proc sybsystemprocs..sp_defaultdb         called by proc sybsystemprocs..sp_modifylogin      called by proc sybsystemprocs..sp_logiosize      called by proc sybsystemprocs..sp_dropuser      called by proc sybsystemprocs..sp_monitor_procstack_usage      called by proc sybsystemprocs..sp_unbindmsg      called by proc sybsystemprocs..sp_start_rep_agent      called by proc sybsystemprocs..sp_jdbc_stored_procedures      called by proc sybsystemprocs..sp_drop_time_range      called by proc sybsystemprocs..sp_dropmessage      called by proc sybsystemprocs..sp_configure         called by proc sybsystemprocs..sp_setlockpromote            called by proc sybsystemprocs..sp_setrowlockpromote            called by proc sybsystemprocs..sp_setpglockpromote         called by proc sybsystemprocs..sp_configure      called by proc sybsystemprocs..sp_addexternlogin      called by proc sybsystemprocs..sp_helpartition         called by proc sybsystemprocs..sp_help      called by proc sybsystemprocs..sp_monitor_disable      called by proc sybsystemprocs..sp_setsuspect_granularity      called by proc sybsystemprocs..sp_helpdevice      called by proc sybsystemprocs..sp_setrepdefmode      called by proc sybsystemprocs..sp_helpgroup         called by proc sybsystemprocs..sp_helpuser      called by proc sybsystemprocs..sp_config_rep_agent      called by proc sybsystemprocs..sp_countmetadata      called by proc sybsystemprocs..sp_helpremotelogin      called by proc sybsystemprocs..sp_jdbc_fkeys         called by proc sybsystemprocs..sp_jdbc_getcrossreferences         called by proc sybsystemprocs..sp_jdbc_exportkey         called by proc sybsystemprocs..sp_jdbc_importkey      called by proc sybsystemprocs..sp_depends_cols         called by proc sybsystemprocs..sp_depends      called by proc sybsystemprocs..sp_dropexternlogin      called by proc sybsystemprocs..sp_rename      called by proc sybsystemprocs..sp_merge_dup_inline_default      called by proc sybsystemprocs..sp_passwordpolicy         called by proc sybsystemprocs..sp_downgrade      called by proc sybsystemprocs..sp_helpsort      called by proc sybsystemprocs..sp_showtext_output         called by proc sybsystemprocs..sp_showtext            called by proc sybsystemprocs..sp_helptext_usage               called by proc sybsystemprocs..sp_helptext            called by proc sybsystemprocs..sp_helptext      called by proc sybsystemprocs..sp_displaylogin      called by proc sybsystemprocs..sp_commonkey      called by proc sybsystemprocs..sp_indsuspect      called by proc sybsystemprocs..sp_addremotelogin      called by proc sybsystemprocs..sp_ijdbc_getbestrowidentifier      called by proc sybsystemprocs..sp_dumpoptimize      called by proc sybsystemprocs..sp_helpindex         called by proc sybsystemprocs..sp_help      called by proc sybsystemprocs..sp_odbc_getprocedurecolumns      called by proc sybsystemprocs..sp_shmdumpconfig      called by proc sybsystemprocs..sp_defaultloc      called by proc sybsystemprocs..sp_droplogin      called by proc sybsystemprocs..sp_ldapadmin      called by proc sybsystemprocs..sp_spaceusage_showhelp_archive         called by proc sybsystemprocs..sp_spaceusage_showhelp_all      called by proc sybsystemprocs..sp_adduser      called by proc sybsystemprocs..sp_renamedb      called by proc sybsystemprocs..sp_setreplicate      called by proc sybsystemprocs..sp_help_query_tuning         called by proc sybsystemprocs..sp_query_tuning      called by proc sybsystemprocs..sp_validateconfigname         called by proc sybsystemprocs..sp_countmetadata         called by proc sybsystemprocs..sp_monitorconfig            called by proc sybsystemprocs..sp_sysmon_mdcache               called by proc sybsystemprocs..sp_sysmon_analyze                  called by proc sybsystemprocs..sp_sysmon         called by proc sybsystemprocs..sp_helpconfig      called by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns      called by proc sybsystemprocs..sp_foreignkey      called by proc sybsystemprocs..sp_role      called by proc sybsystemprocs..sp_setrepproc      called by proc sybsystemprocs..sp_ijdbc_stored_procedures      called by proc sybsystemprocs..sp_dboption      called by proc sybsystemprocs..sp_password         called by proc sybsystemprocs..sp_addlogin      called by proc sybsystemprocs..sp_addsegment      called by proc sybsystemprocs..sp_jdbc_getcolumnprivileges      called by proc sybsystemprocs..sp_errorlog_showhelp         called by proc sybsystemprocs..sp_errorlog      called by proc sybsystemprocs..sp_helprotect      called by proc sybsystemprocs..sp_helpconfig      called by proc sybsystemprocs..sp_forceonline_db      called by proc sybsystemprocs..sp_aux_encr_verify_downgrade      called by proc sybsystemprocs..sp_lock      called by proc sybsystemprocs..sp_forceonline_object      called by proc sybsystemprocs..sp_displaylevel      called by proc sybsystemprocs..sp_logdevice      called by proc sybsystemprocs..sp_ijdbc_tables      called by proc sybsystemprocs..sp_bindmsg      called by proc sybsystemprocs..sp_monitor_enable_usage      called by proc sybsystemprocs..sp_setreptable      called by proc sybsystemprocs..sp_addtabledef      called by proc sybsystemprocs..sp_monitor_report_usage      called by proc sybsystemprocs..sp_jdbc_tables      called by proc sybsystemprocs..sp_tempdb      called by proc sybsystemprocs..sp_dboption_flmode         called by proc sybsystemprocs..sp_dboption      called by proc sybsystemprocs..sp_ijdbc_getindexinfo      called by proc sybsystemprocs..sp_displayroles      called by proc sybsystemprocs..sp_droplanguage      called by proc sybsystemprocs..sp_depends      called by proc sybsystemprocs..sp_ijdbc_fkeys         called by proc sybsystemprocs..sp_ijdbc_getcrossreferences         called by proc sybsystemprocs..sp_ijdbc_exportkey         called by proc sybsystemprocs..sp_ijdbc_importkey      called by proc sybsystemprocs..sp_monitor_help      called by proc sybsystemprocs..sp_shmdumpdisp         called by proc sybsystemprocs..sp_shmdumpconfig      called by proc sybsystemprocs..sp_setrepdbmode      called by proc sybsystemprocs..sp_sproc_columns      called by proc sybsystemprocs..sp_helplanguage      called by proc sybsystemprocs..sp_dropkey      called by proc sybsystemprocs..sp_serveroption      called by proc sybsystemprocs..sp_addlanguage      called by proc sybsystemprocs..sp_locklogin         called by proc sybsystemprocs..sp_addlogin         called by proc sybsystemprocs..sp_droplogin      called by proc sybsystemprocs..sp_setlockpromote      called by proc sybsystemprocs..sp_ijdbc_getversioncolumns      called by proc sybsystemprocs..sp_add_time_range      called by proc sybsystemprocs..sp_helpkey         called by proc sybsystemprocs..sp_help      called by proc sybsystemprocs..sp_addserver      called by proc sybsystemprocs..sp_maplogin      called by proc sybsystemprocs..sp_clearstats      called by proc sybsystemprocs..sp_errorlog      called by proc sybsystemprocs..sp_bindefault      called by proc sybsystemprocs..sp_dropalias      called by proc sybsystemprocs..sp_spaceusage_object_archdata         called by proc sybsystemprocs..sp_spaceusage_object            called by proc sybsystemprocs..sp_spaceusage      called by proc sybsystemprocs..sp_fixindex      called by proc sybsystemprocs..sp_deviceattr      called by proc sybsystemprocs..sp_bindcache         called by proc sybsystemprocs..sp_unbindcache      called by proc sybsystemprocs..sp_tab_suspectptn      called by proc sybsystemprocs..sp_spaceusage_tranlog_archdata         called by proc sybsystemprocs..sp_spaceusage_tranlog            called by proc sybsystemprocs..sp_spaceusage      called by proc sybsystemprocs..sp_spaceusage_showhelp      called by proc sybsystemprocs..sp_extendsegment      called by proc sybsystemprocs..sp_droplockpromote         called by proc sybsystemprocs..sp_droprowlockpromote         called by proc sybsystemprocs..sp_dropglockpromote      called by proc sybsystemprocs..sp_reptostandby      called by proc sybsystemprocs..sp_dropdevice      called by proc sybsystemprocs..sp_monitor_archive_usage      called by proc sybsystemprocs..sp_logintrigger         called by proc sybsystemprocs..sp_modifylogin      called by proc sybsystemprocs..sp_add_resource_limit      called by proc sybsystemprocs..sp_placeobject      called by proc sybsystemprocs..sp_listsuspect_page      called by proc sybsystemprocs..sp_monitorconfig      called by proc sybsystemprocs..sp_monitor_disable_usage      called by proc sybsystemprocs..sp_addlogin      called by proc sybsystemprocs..sp_dropremotelogin      called by proc sybsystemprocs..sp_cmp_all_qplans      called by proc sybsystemprocs..sp_monitor_deadlock_usage         called by proc sybsystemprocs..sp_monitor_deadlock            called by proc sybsystemprocs..sp_monitor      called by proc sybsystemprocs..sp_drop_resource_limit      called by proc sybsystemprocs..sp_jdbc_getindexinfo      called by proc sybsystemprocs..sp_addumpdevice      called by proc sybsystemprocs..sp_changedbowner      called by proc sybsystemprocs..sp_help      called by proc sybsystemprocs..sp_dropsegment      called by proc sybsystemprocs..sp_helpuser      called by proc sybsystemprocs..sp_addmessage      called by proc sybsystemprocs..sp_helplog      called by proc sybsystemprocs..sp_monitor_deadlock_count_by         called by proc sybsystemprocs..sp_monitor_deadlock      called by proc sybsystemprocs..sp_ijdbc_columns      called by proc sybsystemprocs..sp_stop_rep_agent      called by proc sybsystemprocs..sp_mon_archive_data         called by proc sybsystemprocs..sp_mon_archive_monTable            called by proc sybsystemprocs..sp_mon_archive_deadlock      called by proc sybsystemprocs..sp_fkeys      called by proc sybsystemprocs..sp_spaceusage_showhelp_report         called by proc sybsystemprocs..sp_spaceusage_showhelp_all      called by proc sybsystemprocs..sp_help_metrics         called by proc sybsystemprocs..sp_metrics      called by proc sybsystemprocs..sp_monitor_list_montypes         called by proc sybsystemprocs..sp_monitor_list      called by proc sybsystemprocs..sp_changegroup      called by proc sybsystemprocs..sp_setsuspect_threshold      called by proc sybsystemprocs..sp_unbindrule      called by proc sybsystemprocs..sp_jdbc_primarykey      called by proc sybsystemprocs..sp_unbindefault      called by proc sybsystemprocs..sp_bindrule      called by proc sybsystemprocs..sp_ddlgen_help      called by proc sybsystemprocs..sp_helpcomputedcolumn         called by proc sybsystemprocs..sp_helpindex         called by proc sybsystemprocs..sp_help      called by proc sybsystemprocs..sp_revokelogin      called by proc sybsystemprocs..sp_jdbc_getfunctioncolumns      called by proc sybsystemprocs..sp_spaceusage_object_genoutput         called by proc sybsystemprocs..sp_spaceusage_object      called by proc sybsystemprocs..sp_addalias      called by proc sybsystemprocs..sp_setsuspect_error      called by proc sybsystemprocs..sp_addgroup      called by proc sybsystemprocs..sp_check_remote_tempdb      called by proc sybsystemprocs..sp_modifylogin      called by proc sybsystemprocs..sp_showtext_usage         called by proc sybsystemprocs..sp_showtext_output         called by proc sybsystemprocs..sp_showtext      called by proc sybsystemprocs..sp_primarykey      called by proc sybsystemprocs..sp_cmp_qplans         called by proc sybsystemprocs..sp_copy_qplan            called by proc sybsystemprocs..sp_copy_all_qplans      called by proc sybsystemprocs..sp_jdbc_getversioncolumns      called by proc sybsystemprocs..sp_monitor_archive         called by proc sybsystemprocs..sp_monitor_deadlock      called by proc sybsystemprocs..sp_oledb_getprocedurecolumns      called by proc sybsystemprocs..sp_forceonline_page         called by proc sybsystemprocs..sp_forceonline_db      called by proc sybsystemprocs..sp_helpdb      called by proc sybsystemprocs..sp_grantlogin      called by proc sybsystemprocs..sp_jdbc_getprocedurecolumns      called by proc sybsystemprocs..sp_helpserver      called by proc sybsystemprocs..sp_helpsegment      called by proc sybsystemprocs..sp_helpconstraint      called by proc sybsystemprocs..sp_volchanged      called by proc sybsystemprocs..sp_spaceusage_runcmd         called by proc sybsystemprocs..sp_spaceusage      called by proc sybsystemprocs..sp_modifythreshold      called by proc sybsystemprocs..sp_showpsexe      called by proc sybsystemprocs..sp_familylock      called by proc sybsystemprocs..sp_dropserver      called by proc sybsystemprocs..sp_jdbc_getbestrowidentifier      called by proc sybsystemprocs..sp_plan_dbccdb      called by proc sybsystemprocs..sp_monitor_connection_usage      called by proc sybsystemprocs..sp_objectsegment      called by proc sybsystemprocs..sp_setlangalias      called by proc sybsystemprocs..sp_jdbc_columns      called by proc sybsystemprocs..sp_odbc_fkeys      called by proc sybsystemprocs..sp_monitor_list      called by proc sybsystemprocs..sp_chgattribute      called by proc sybsystemprocs..sp_spaceusage_object_populate         called by proc sybsystemprocs..sp_spaceusage_object      called by proc sybsystemprocs..sp_helpjava      called by proc sybsystemprocs..sp_dropgroup      called by proc sybsystemprocs..sp_remoteoption      called by proc sybsystemprocs..sp_addtype      called by proc sybsystemprocs..sp_addthreshold      called by proc sybsystemprocs..sp_autoconnect      called by proc sybsystemprocs..sp_droptype      called by proc sybsystemprocs..sp_monitor_procstack      called by proc sybsystemprocs..sp_spaceusage_tranlog_genoutput         called by proc sybsystemprocs..sp_spaceusage_tranlog      called by proc sybsystemprocs..sp_serverinfo         called by proc sybsystemprocs..sp_inform      called by proc sybsystemprocs..sp_ijdbc_getcolumnprivileges      called by proc sybsystemprocs..sp_compatmode      called by proc sybsystemprocs..sp_ijdbc_primarykey      called by proc sybsystemprocs..sp_listsuspect_db      called by proc sybsystemprocs..sp_defaultlanguage         called by proc sybsystemprocs..sp_modifylogin      called by proc sybsystemprocs..sp_recompile      called by proc sybsystemprocs..sp_encryption         called by proc sybsystemprocs..sp_downgrade   called by proc sybsystemprocs..sp_droplanguage   called by proc sybsystemprocs..sp_defaultlanguage   called by proc sybsystemprocs..sp_dropmessage   called by proc sybsystemprocs..sp_addlogin