DatabaseProcApplicationCreatedLinks
sybsystemprocssp_validlang  14 déc. 14Defects Propagation Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/src/%M% %I% %G%" */
3     /*	4.8	1.1	06/14/90	sproc/src/serveroption */
4     create or replace 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: 3 = 3dec - 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_addmessage  
called by proc sybsystemprocs..sp_getmessage  
   called by proc sybsystemprocs..sp_changedbowner  
   called by proc sybsystemprocs..sp_dropexternlogin  
   called by proc sybsystemprocs..sp_unbindmsg  
   called by proc sybsystemprocs..sp_helpdb  
   called by proc sybsystemprocs..sp_setrepdefmode  
   called by proc sybsystemprocs..sp_changegroup  
   called by proc sybsystemprocs..sp_help_qpgroup  
   called by proc sybsystemprocs..sp_extendsegment  
   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_stop_rep_agent  
   called by proc sybsystemprocs..sp_helplog  
   called by proc sybsystemprocs..sp_droptype  
   called by proc sybsystemprocs..sp_locklogin  
      called by proc sybsystemprocs..sp_addlogin  
   called by proc sybsystemprocs..sp_showpsexe  
   called by proc sybsystemprocs..sp_bindcache  
      called by proc sybsystemprocs..sp_unbindcache  
   called by proc sybsystemprocs..sp_shmdumpdisp  
      called by proc sybsystemprocs..sp_shmdumpconfig  
   called by proc sybsystemprocs..sp_addumpdevice  
   called by proc sybsystemprocs..sp_droplockpromote  
      called by proc sybsystemprocs..sp_droprowlockpromote  
      called by proc sybsystemprocs..sp_dropglockpromote  
   called by proc sybsystemprocs..sp_deviceattr  
   called by proc sybsystemprocs..sp_ijdbc_getbestrowidentifier  
   called by proc sybsystemprocs..sp_tempdb  
   called by proc sybsystemprocs..sp_spaceusage_tranlog_genoutput  
      called by proc sybsystemprocs..sp_spaceusage_tranlog  
         called by proc sybsystemprocs..sp_spaceusage  
   called by proc sybsystemprocs..sp_monitor_procstack_usage  
   called by proc sybsystemprocs..sp_ijdbc_columns  
   called by proc sybsystemprocs..sp_drop_time_range  
   called by proc sybsystemprocs..sp_oledb_getprocedurecolumns  
   called by proc sybsystemprocs..sp_displaylogin  
   called by proc sybsystemprocs..sp_monitor_archive_usage  
   called by proc sybsystemprocs..sp_droplanguage  
   called by proc sybsystemprocs..sp_monitor_list  
   called by proc sybsystemprocs..sp_renamedb  
   called by proc sybsystemprocs..sp_addtabledef  
   called by proc sybsystemprocs..sp_unbindefault  
   called by proc sybsystemprocs..sp_ddlgen_help  
   called by proc sybsystemprocs..sp_maplogin  
   called by proc sybsystemprocs..sp_ijdbc_getversioncolumns  
   called by proc sybsystemprocs..sp_help_metrics  
      called by proc sybsystemprocs..sp_metrics  
   called by proc sybsystemprocs..sp_monitor_archive  
      called by proc sybsystemprocs..sp_monitor_deadlock  
         called by proc sybsystemprocs..sp_monitor  
   called by proc sybsystemprocs..sp_dropuser  
   called by proc sybsystemprocs..sp_setrepcol  
   called by proc sybsystemprocs..sp_spaceusage_showhelp  
      called by proc sybsystemprocs..sp_spaceusage  
   called by proc sybsystemprocs..sp_dropsegment  
   called by proc sybsystemprocs..sp_dropkey  
   called by proc sybsystemprocs..sp_helpdevice  
   called by proc sybsystemprocs..sp_helprotect  
   called by proc sybsystemprocs..sp_countmetadata  
   called by proc sybsystemprocs..sp_forceonline_object  
   called by proc sybsystemprocs..sp_addremotelogin  
   called by proc sybsystemprocs..sp_ijdbc_tables  
   called by proc sybsystemprocs..sp_monitor_help  
   called by proc sybsystemprocs..sp_jdbc_getbestrowidentifier  
   called by proc sybsystemprocs..sp_addmessage  
   called by proc sybsystemprocs..sp_start_rep_agent  
   called by proc sybsystemprocs..sp_primarykey  
   called by proc sybsystemprocs..sp_monitor_procstack  
   called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_defaultloc  
   called by proc sybsystemprocs..sp_bindmsg  
   called by proc sybsystemprocs..sp_fixindex  
   called by proc sybsystemprocs..sp_logintrigger  
      called by proc sybsystemprocs..sp_modifylogin  
   called by proc sybsystemprocs..sp_helpdefrag  
   called by proc sybsystemprocs..sp_config_rep_agent  
   called by proc sybsystemprocs..sp_helpconfig  
      called by proc sybsystemprocs..sp_helpconfig_gen_estimates_cpi  
         called by proc sybsystemprocs..sp_helpconfig_est_compinfo_poolsize  
   called by proc sybsystemprocs..sp_addtype  
   called by proc sybsystemprocs..sp_tab_suspectptn  
   called by proc sybsystemprocs..sp_addexternlogin  
   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_helpjava  
   called by proc sybsystemprocs..sp_indsuspect  
   called by proc sybsystemprocs..sp_jdbc_tables  
   called by proc sybsystemprocs..sp_spaceusage_showhelp_archive  
      called by proc sybsystemprocs..sp_spaceusage_showhelp_all  
         called by proc sybsystemprocs..sp_spaceusage_showhelp  
   called by proc sybsystemprocs..sp_modifylogin  
   called by proc sybsystemprocs..sp_restore_system_role  
   called by proc sybsystemprocs..sp_setsuspect_granularity  
   called by proc sybsystemprocs..sp_shmdumpconfig  
   called by proc sybsystemprocs..sp_setlangalias  
   called by proc sybsystemprocs..sp_spaceusage_object_populate  
      called by proc sybsystemprocs..sp_spaceusage_object  
         called by proc sybsystemprocs..sp_spaceusage  
   called by proc sybsystemprocs..sp_familylock  
   called by proc sybsystemprocs..sp_logdevice  
   called by proc sybsystemprocs..sp_helpuser  
   called by proc sybsystemprocs..sp_addlanguage  
   called by proc sybsystemprocs..sp_serverinfo  
      called by proc sybsystemprocs..sp_inform  
   called by proc sybsystemprocs..sp_setrepdbmode  
   called by proc sybsystemprocs..sp_setlockpromote  
      called by proc sybsystemprocs..sp_setpglockpromote  
      called by proc sybsystemprocs..sp_setrowlockpromote  
   called by proc sybsystemprocs..sp_drop_resource_limit  
   called by proc sybsystemprocs..sp_dboption  
   called by proc sybsystemprocs..sp_monitor_disable  
   called by proc sybsystemprocs..sp_monitor_connection_usage  
   called by proc sybsystemprocs..sp_setsuspect_threshold  
   called by proc sybsystemprocs..sp_addsegment  
   called by proc sybsystemprocs..sp_dropdevice  
   called by proc sybsystemprocs..sp_odbc_getprocedurecolumns  
   called by proc sybsystemprocs..sp_ijdbc_fkeys  
      called by proc sybsystemprocs..sp_ijdbc_getcrossreferences  
      called by proc sybsystemprocs..sp_ijdbc_importkey  
      called by proc sybsystemprocs..sp_ijdbc_exportkey  
   called by proc sybsystemprocs..sp_addserver  
   called by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
   called by proc sybsystemprocs..sp_ijdbc_primarykey  
   called by proc sybsystemprocs..sp_dropgroup  
   called by proc sybsystemprocs..sp_add_time_range  
   called by proc sybsystemprocs..sp_helpartition  
      called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_setsuspect_error  
   called by proc sybsystemprocs..sp_helpcomputedcolumn  
      called by proc sybsystemprocs..sp_help  
      called by proc sybsystemprocs..sp_helpindex  
         called by proc sybsystemprocs..sp_help  
   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_listsuspect_db  
   called by proc sybsystemprocs..sp_serveroption  
   called by proc sybsystemprocs..sp_defaultdb  
      called by proc sybsystemprocs..sp_modifylogin  
   called by proc sybsystemprocs..sp_monitor_deadlock_count_by  
      called by proc sybsystemprocs..sp_monitor_deadlock  
   called by proc sybsystemprocs..sp_helpkey  
      called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_defaultlanguage  
      called by proc sybsystemprocs..sp_modifylogin  
   called by proc sybsystemprocs..sp_commonkey  
   called by proc sybsystemprocs..sp_check_remote_tempdb  
      called by proc sybsystemprocs..sp_restore_system_role  
      called by proc sybsystemprocs..sp_ddlgen_permissions  
   called by proc sybsystemprocs..sp_monitor_list_montypes  
      called by proc sybsystemprocs..sp_monitor_list  
   called by proc sybsystemprocs..sp_helpconfig_usage  
      called by proc sybsystemprocs..sp_helpconfig  
   called by proc sybsystemprocs..sp_dropalias  
   called by proc sybsystemprocs..sp_compatmode  
   called by proc sybsystemprocs..sp_rename  
   called by proc sybsystemprocs..sp_helpgroup  
      called by proc sybsystemprocs..sp_helpuser  
   called by proc sybsystemprocs..sp_configure  
      called by proc sybsystemprocs..sp_downgrade_esd  
      called by proc sybsystemprocs..sp_configure  
      called by proc sybsystemprocs..sp_setlockpromote  
   called by proc sybsystemprocs..sp_jdbc_getindexinfo  
   called by proc sybsystemprocs..sp_droplockpromote_ptn  
      called by proc sybsystemprocs..sp_dropglockpromote_ptn  
      called by proc sybsystemprocs..sp_droprowlockpromote_ptn  
   called by proc sybsystemprocs..sp_monitor_disable_usage  
   called by proc sybsystemprocs..sp_help_query_tuning  
      called by proc sybsystemprocs..sp_query_tuning  
   called by proc sybsystemprocs..sp_setrepproc  
   called by proc sybsystemprocs..sp_dropserver  
      called by proc sybsystemprocs..sp_hadr_admin  
         called by proc sybsystemprocs..sp_hadr_update  
   called by proc sybsystemprocs..sp_errorlog_showhelp  
      called by proc sybsystemprocs..sp_errorlog  
   called by proc sybsystemprocs..sp_role  
      called by proc master..mon_authorize_non_sa  
   called by proc sybsystemprocs..sp_addlogin  
   called by proc sybsystemprocs..sp_jdbc_columns  
   called by proc sybsystemprocs..sp_logging_rate  
   called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_grantlogin  
   called by proc sybsystemprocs..sp_helplanguage  
   called by proc sybsystemprocs..sp_monitor_report_usage  
   called by proc sybsystemprocs..sp_adduser  
   called by proc sybsystemprocs..sp_hadr_admin  
   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_spaceusage_object_archdata  
      called by proc sybsystemprocs..sp_spaceusage_object  
   called by proc sybsystemprocs..sp_clearstats  
   called by proc sybsystemprocs..sp_depends_cols  
      called by proc sybsystemprocs..sp_depends  
   called by proc sybsystemprocs..sp_help_rep_agent  
   called by proc sybsystemprocs..sp_jdbc_getprocedurecolumns  
   called by proc sybsystemprocs..sp_merge_dup_inline_default  
   called by proc sybsystemprocs..sp_addgroup  
   called by proc sybsystemprocs..sp_placeobject  
   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_helptext_usage  
               called by proc sybsystemprocs..sp_helptext  
            called by proc sybsystemprocs..sp_helptext  
      called by proc sybsystemprocs..sp_showtext  
   called by proc sybsystemprocs..sp_jdbc_getfunctioncolumns  
   called by proc sybsystemprocs..sp_helpserver  
   called by proc sybsystemprocs..sp_chgattribute  
   called by proc sybsystemprocs..sp_spaceusage_runcmd  
      called by proc sybsystemprocs..sp_spaceusage  
   called by proc sybsystemprocs..sp_forceonline_page  
      called by proc sybsystemprocs..sp_forceonline_db  
   called by proc sybsystemprocs..sp_bindrule  
   called by proc sybsystemprocs..sp_reptostandby  
   called by proc sybsystemprocs..sp_setreptable  
   called by proc sybsystemprocs..sp_volchanged  
   called by proc sybsystemprocs..sp_jdbc_stored_procedures  
   called by proc sybsystemprocs..sp_ldapadmin  
   called by proc sybsystemprocs..sp_passwordpolicy  
      called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_dboption_flmode  
      called by proc sybsystemprocs..sp_dboption  
   called by proc sybsystemprocs..sp_jdbc_primarykey  
   called by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns  
   called by proc sybsystemprocs..sp_unbindrule  
   called by proc sybsystemprocs..sp_dumpoptimize  
   called by proc sybsystemprocs..sp_addalias  
   called by proc sybsystemprocs..sp_ijdbc_getcolumnprivileges  
   called by proc sybsystemprocs..sp_foreignkey  
   called by proc sybsystemprocs..sp_helpsegment  
   called by proc sybsystemprocs..sp_revokelogin  
   called by proc sybsystemprocs..sp_dropremotelogin  
   called by proc sybsystemprocs..sp_bindefault  
   called by proc sybsystemprocs..sp_ijdbc_getindexinfo  
   called by proc sybsystemprocs..sp_fkeys  
   called by proc sybsystemprocs..sp_lock  
   called by proc sybsystemprocs..sp_logiosize  
   called by proc sybsystemprocs..sp_dropmessage  
   called by proc sybsystemprocs..sp_spaceusage_tranlog_archdata  
      called by proc sybsystemprocs..sp_spaceusage_tranlog  
   called by proc sybsystemprocs..sp_encryption  
      called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_monitor_deadlock_usage  
      called by proc sybsystemprocs..sp_monitor_deadlock  
   called by proc sybsystemprocs..sp_setreplicate  
   called by proc sybsystemprocs..sp_displaylevel  
   called by proc sybsystemprocs..sp_helpsort  
   called by proc sybsystemprocs..sp_jdbc_getversioncolumns  
   called by proc sybsystemprocs..sp_monitor_enable_usage  
   called by proc sybsystemprocs..sp_add_resource_limit  
   called by proc sybsystemprocs..sp_displayroles  
   called by proc sybsystemprocs..sp_showtext_output  
   called by proc sybsystemprocs..sp_spaceusage_showhelp_display  
      called by proc sybsystemprocs..sp_spaceusage_showhelp_all  
   called by proc sybsystemprocs..sp_addthreshold  
   called by proc sybsystemprocs..sp_recompile  
   called by proc sybsystemprocs..sp_odbc_fkeys  
   called by proc sybsystemprocs..sp_helptrigger  
   called by proc sybsystemprocs..sp_forceonline_db  
   called by proc sybsystemprocs..sp_modifythreshold  
   called by proc sybsystemprocs..sp_spaceusage_object_genoutput  
      called by proc sybsystemprocs..sp_spaceusage_object  
   called by proc sybsystemprocs..sp_optgoal  
   called by proc sybsystemprocs..sp_validateconfigname  
      called by proc sybsystemprocs..sp_countmetadata  
      called by proc sybsystemprocs..sp_monitorconfig  
      called by proc sybsystemprocs..sp_helpconfig  
   called by proc sybsystemprocs..sp_remoteoption  
   called by proc sybsystemprocs..sp_cmp_all_qplans  
   called by proc sybsystemprocs..sp_dropthreshold  
   called by proc sybsystemprocs..sp_errorlog  
   called by proc sybsystemprocs..sp_password  
      called by proc sybsystemprocs..sp_addlogin  
   called by proc sybsystemprocs..sp_plan_dbccdb  
   called by proc sybsystemprocs..sp_spaceusage_showhelp_report  
      called by proc sybsystemprocs..sp_spaceusage_showhelp_all  
   called by proc sybsystemprocs..sp_autoconnect  
   called by proc sybsystemprocs..sp_sproc_columns  
   called by proc sybsystemprocs..sp_helpconstraint  
   called by proc sybsystemprocs..sp_helpindex  
   called by proc sybsystemprocs..sp_ijdbc_stored_procedures  
   called by proc sybsystemprocs..sp_listsuspect_page  
   called by proc sybsystemprocs..sp_downgrade_esd  
   called by proc sybsystemprocs..sp_objectsegment  
   called by proc sybsystemprocs..sp_helpremotelogin  
   called by proc sybsystemprocs..sp_depends  
   called by proc sybsystemprocs..sp_setlockpromote_ptn  
      called by proc sybsystemprocs..sp_setpglockpromote_ptn  
      called by proc sybsystemprocs..sp_setrowlockpromote_ptn  
called by proc sybsystemprocs..sp_dropmessage  
called by proc sybsystemprocs..sp_addlogin  
called by proc sybsystemprocs..sp_defaultlanguage  
called by proc sybsystemprocs..sp_setlangalias  
called by proc sybsystemprocs..sp_droplanguage  
called by proc sybsystemprocs..sp_addlanguage