DatabaseProcApplicationCreatedLinks
sybsystemprocssp_dbxt_recreate_proc  31 Aug 14Defects Dependencies

1     
2     /*
3     {
4     */
5     create procedure sp_dbxt_recreate_proc(@procname varchar(256)) as
6         begin
7             if exists (select 1 from sysobjects
8                     where id = object_id(@procname)
9                         and type = 'P'
10                        and sysstat & 7 = 4
11                    )
12            begin
13                print "Re-installing %1!", @procname
14                exec ("drop procedure " + @procname)
15            end
16            else
17            begin
18                print "Installing %1!", @procname
19            end
20        end
21    


exec sp_procxmode 'sp_dbxt_recreate_proc', 'AnyMode'
go

Grant Execute on sp_dbxt_recreate_proc to public
go
DEFECTS
 MPSI 4 Possible SQL Injection @procname 14
 MDYN 3 Proc uses Dynamic SQL but is not flagged with Dynamic Ownership Chain 5
 MGTP 3 Grant to public sybsystemprocs..sp_dbxt_recreate_proc  
 MGTP 3 Grant to public sybsystemprocs..sysobjects  
 MUCO 3 Useless Code Useless Brackets in create proc 5
 MUCO 3 Useless Code Useless Begin-End Pair 6
 MDYS 2 Dynamic SQL Marker 14
 MSUB 2 Subquery Marker 7
 MTR1 2 Metrics: Comments Ratio Comments: 0% 5
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 4 = 3dec - 1exi + 2 5
 MTR3 2 Metrics: Query Complexity Complexity: 10 5

DEPENDENCIES
PROCS AND TABLES USED
reads table sybsystemprocs..sysobjects