DatabaseProcApplicationCreatedLinks
sybsystemprocssp_dwngd_helpindex  14 déc. 14Defects Propagation Dependencies

1     
2     /*
3     ** Generated by spgenmsgs.pl on Thu Aug 15 21:31:33 2013 
4     */
5     /*
6     ** raiserror Messages for downgrade_esd [Total 2]
7     **
8     ** 17428, "You must be in the 'master' database in order to change database options."
9     ** 17590, "The specified database does not exist."
10    */
11    /*
12    ** sp_getmessage Messages for downgrade_esd [Total 2]
13    **
14    ** 19112, "Running CHECKPOINT on database '%1!' for option '%2!' to take effect."
15    ** 19113, "CHECKPOINT command failed. Run the CHECKPOINT command in database '%1!' for the change to take effect."
16    */
17    /*
18    ** End spgenmsgs.pl output.
19    */
20    
21    /*
22    **			*** HELPER PROCEDURES ****
23    */
24    
25    /*
26    ** SP_DWNGD_HELPINDEX
27    **
28    **	Display the list of tables with offending indexes using RID value
29    **	comparison.
30    {
31    */
32    create or replace procedure sp_dwngd_helpindex
33    as
34        begin
35            set nocount on
36    
37            select owner_name = user_name(o.uid)
38                , table_name = o.name
39                , index_name = i.name
40            into #dwngd_helpindex
41            from sysindexes i
42            , sysobjects o
43            where i.id = o.id
44                and (i.status & 256) = 256
45    
46            exec sp_autoformat #dwngd_helpindex
47    
48        end
49    


exec sp_procxmode 'sp_dwngd_helpindex', 'AnyMode'
go

Grant Execute on sp_dwngd_helpindex to public
go
DEFECTS
 MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: parameter # 1 46
 MAW1 3 Warning message on %name% sybsystemprocs..sysindexes.id: Warning message on sysindexes 43
 MAW1 3 Warning message on %name% sybsystemprocs..sysobjects.id: Warning message on sysobjects 43
 MGTP 3 Grant to public sybsystemprocs..sp_dwngd_helpindex  
 MGTP 3 Grant to public sybsystemprocs..sysindexes  
 MGTP 3 Grant to public sybsystemprocs..sysobjects  
 MNER 3 No Error Check should check @@error after select into 37
 MNER 3 No Error Check should check return value of exec 46
 MUCO 3 Useless Code Useless Begin-End Pair 34
 QNAJ 3 Not using ANSI Inner Join 41
 MTR1 2 Metrics: Comments Ratio Comments: 54% 32
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2 32
 MTR3 2 Metrics: Query Complexity Complexity: 9 32
 PRED_QUERY_COLLECTION 2 {i=sybsystemprocs..sysindexes, o=sybsystemprocs..sysobjects} 0 37

DEPENDENCIES
PROCS AND TABLES USED
reads table sybsystemprocs..sysindexes  
writes table tempdb..#dwngd_helpindex (1) 
reads table sybsystemprocs..sysobjects  
calls proc sybsystemprocs..sp_autoformat  
   reads table master..syscolumns (1)  
   reads table tempdb..syscolumns (1)  
   writes table sybsystemprocs..sp_autoformat_rset_002 
   reads table master..systypes (1)  
   writes table sybsystemprocs..sp_autoformat_rset_003 
   calls proc sybsystemprocs..sp_namecrack  
   reads table tempdb..systypes (1)  
   writes table sybsystemprocs..sp_autoformat_rset_001 
   writes table sybsystemprocs..sp_autoformat_rset_004 
   calls proc sybsystemprocs..sp_autoformat  
   writes table sybsystemprocs..sp_autoformat_rset_005 
   read_writes table tempdb..#colinfo_af (1)