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

1     
2     create 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: 5 = 5dec - 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_dropserver   called by proc sybsystemprocs..sp_drop_time_range   called by proc sybsystemprocs..sp_addlogin   called by proc sybsystemprocs..sp_addalias   called by proc sybsystemprocs..sp_addgroup   called by proc sybsystemprocs..sp_droplanguage   called by proc sybsystemprocs..sp_setlangalias   called by proc sybsystemprocs..sp_update_authmech_value   called by proc sybsystemprocs..sp_add_resource_limit   called by proc sybsystemprocs..sp_adduser   called by proc sybsystemprocs..sp_dboption_flmode      called by proc sybsystemprocs..sp_dboption   called by proc sybsystemprocs..sp_serveroption   called by proc sybsystemprocs..sp_addremotelogin   called by proc sybsystemprocs..sp_changedbowner   called by proc sybsystemprocs..sp_maplogin   called by proc sybsystemprocs..sp_changegroup   called by proc sybsystemprocs..sp_dropgroup   called by proc sybsystemprocs..sp_modify_resource_limit   called by proc sybsystemprocs..sp_dropexternlogin   called by proc sybsystemprocs..sp_drop_resource_limit   called by proc sybsystemprocs..sp_droplogin   called by proc sybsystemprocs..sp_add_time_range   called by proc sybsystemprocs..sp_passwordpolicy      called by proc sybsystemprocs..sp_downgrade   called by proc sybsystemprocs..sp_addserver   called by proc sybsystemprocs..sp_addlanguage   called by proc sybsystemprocs..sp_defaultdb      called by proc sybsystemprocs..sp_modifylogin   called by proc sybsystemprocs..sp_addtype   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_dropalias   called by proc sybsystemprocs..sp_droptype   called by proc sybsystemprocs..sp_renamedb   called by proc sybsystemprocs..sp_logintrigger      called by proc sybsystemprocs..sp_modifylogin   called by proc sybsystemprocs..sp_locklogin      called by proc sybsystemprocs..sp_droplogin      called by proc sybsystemprocs..sp_addlogin   called by proc sybsystemprocs..sp_defaultlanguage      called by proc sybsystemprocs..sp_modifylogin   called by proc sybsystemprocs..sp_addexternlogin   called by proc sybsystemprocs..sp_dropuser   called by proc sybsystemprocs..sp_remoteoption   called by proc sybsystemprocs..sp_modifylogin