DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ha_check_certified  14 déc. 14Defects Propagation Dependencies

1     
2     create or replace procedure sp_ha_check_certified
3         @proc_name varchar(100),
4         @ha_certified tinyint
5     as
6     
7         declare @IN_install tinyint /* Is installmaster/installhasvss
8         ** in progress ?
9         */
10        set nocount on
11        select @IN_install = 0
12    
13        /* See if we are using HA specific SP for a HA enabled server */
14    
15        if ((@@cmpstate > 0) and (@ha_certified = 0))
16        begin
17            if (exists (select 1 from tempdb.dbo.sysobjects where
18                            name = 'ha_temp_install' and type = 'U'))
19            begin
20                select @IN_install = 1
21            end
22    
23            /*
24            ** During installmaster/installhasvss, we do not want to raise
25            ** an error when a non HA version of the SP is invoked.
26            */
27            if (@IN_install = 0)
28            begin
29                /*raiserror 18842, @@servername, @proc_name */
30                print "Server '%1!' is booted with 'enable HA configuration option', but the procedure '%2!' is not of HA version. Please check if 'installhasvss' has been run.", @@servername, @proc_name
31                return (1)
32            end
33        end
34    
35        set nocount off
36        return (0)
37    
38    


exec sp_procxmode 'sp_ha_check_certified', 'AnyMode'
go
DEFECTS
 MULT 4 Using literal database 'tempdb' tempdb..sysobjects 17
 MGTP 3 Grant to public tempdb..sysobjects  
 MUCO 3 Useless Code Useless Brackets 15
 MUCO 3 Useless Code Useless Brackets 17
 MUCO 3 Useless Code Useless Brackets 27
 MUCO 3 Useless Code Useless Brackets 31
 MUCO 3 Useless Code Useless Brackets 36
 QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
18
 MSUB 2 Subquery Marker 17
 MTR1 2 Metrics: Comments Ratio Comments: 29% 2
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 6 = 6dec - 2exi + 2 2
 MTR3 2 Metrics: Query Complexity Complexity: 19 2

DEPENDENCIES
PROCS AND TABLES USED
reads table tempdb..sysobjects (1)  

CALLERS
called by proc sybsystemprocs..sp_droplanguage  
called by proc sybsystemprocs..sp_remoteoption  
called by proc sybsystemprocs..sp_add_resource_limit  
called by proc sybsystemprocs..sp_defaultlanguage  
   called by proc sybsystemprocs..sp_modifylogin  
called by proc sybsystemprocs..sp_drop_resource_limit  
called by proc sybsystemprocs..sp_addlogin  
called by proc sybsystemprocs..sp_modify_resource_limit  
called by proc sybsystemprocs..sp_setlangalias  
called by proc sybsystemprocs..sp_add_time_range  
called by proc sybsystemprocs..sp_changegroup  
called by proc sybsystemprocs..sp_passwordpolicy  
   called by proc sybsystemprocs..sp_downgrade  
called by proc sybsystemprocs..sp_serveroption  
called by proc sybsystemprocs..sp_droptype  
called by proc sybsystemprocs..sp_addalias  
called by proc sybsystemprocs..sp_defaultdb  
   called by proc sybsystemprocs..sp_modifylogin  
called by proc sybsystemprocs..sp_drop_time_range  
called by proc sybsystemprocs..sp_addserver  
called by proc sybsystemprocs..sp_addexternlogin  
called by proc sybsystemprocs..sp_logintrigger  
   called by proc sybsystemprocs..sp_modifylogin  
called by proc sybsystemprocs..sp_dropalias  
called by proc sybsystemprocs..sp_dropgroup  
called by proc sybsystemprocs..sp_locklogin  
   called by proc sybsystemprocs..sp_addlogin  
called by proc sybsystemprocs..sp_update_authmech_value  
called by proc sybsystemprocs..sp_modify_time_range  
called by proc sybsystemprocs..sp_password  
   called by proc sybsystemprocs..sp_addlogin  
called by proc sybsystemprocs..sp_dropexternlogin  
called by proc sybsystemprocs..sp_changedbowner  
called by proc sybsystemprocs..sp_adduser  
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_modifylogin  
called by proc sybsystemprocs..sp_dropuser  
called by proc sybsystemprocs..sp_renamedb  
called by proc sybsystemprocs..sp_addlanguage  
called by proc sybsystemprocs..sp_addremotelogin  
called by proc sybsystemprocs..sp_dboption_flmode  
   called by proc sybsystemprocs..sp_dboption  
called by proc sybsystemprocs..sp_maplogin  
called by proc sybsystemprocs..sp_addgroup  
called by proc sybsystemprocs..sp_addtype