DatabaseProcApplicationCreatedLinks
sybsystemprocssp_unbindcache  31 Aug 14Defects Dependencies

1     
2     /* Stored procedure for unbinding entites that are bound to named caches.
3     **
4     ** Databases can only be unbound when using Master.
5     */
6     create procedure sp_unbindcache
7         @dbname varchar(255),
8         @tablename varchar(512) = NULL,
9         @indexname varchar(255) = NULL
10    as
11    
12        declare @returncode smallint
13    
14        /*
15        **  Don't allow this in a transaction because we can't undo what
16        **  the bind_cache() builtin has done.
17        */
18        if @@trancount > 0
19        begin
20            /*
21            ** 17260, "Can't run %1! from within a transaction."
22            */
23            raiserror 17260, "sp_unbindcache"
24            return (1)
25        end
26        else
27        begin
28            set chained off
29        end
30    
31        set transaction isolation level 1
32    
33        /* check if user has sa role, proc_role will also do auditing
34        ** if required. proc_role will also print error message if required.
35        */
36        if (proc_role("sa_role") = 0)
37            return (1)
38    
39        execute @returncode = sp_bindcache NULL, @dbname, @tablename, @indexname
40    
41        return @returncode
42    


exec sp_procxmode 'sp_unbindcache', 'AnyMode'
go

Grant Execute on sp_unbindcache to public
go
DEFECTS
 MTYP 4 Assignment type mismatch @dbname: varchar(30) = varchar(255) 39
 MGTP 3 Grant to public sybsystemprocs..sp_unbindcache  
 MNER 3 No Error Check should check return value of exec 39
 MUCO 3 Useless Code Useless Brackets 24
 MUCO 3 Useless Code Useless Brackets 36
 MUCO 3 Useless Code Useless Brackets 37
 QISO 3 Set isolation level 31
 MTR1 2 Metrics: Comments Ratio Comments: 41% 6
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 2dec - 2exi + 2 6
 MTR3 2 Metrics: Query Complexity Complexity: 13 6

DEPENDENCIES
PROCS AND TABLES USED
calls proc sybsystemprocs..sp_bindcache  
   calls proc sybsystemprocs..sp_aux_parse_entity  
      reads table sybsystemprocs..sysindexes  
      reads table sybsystemprocs..sysobjects  
   reads table master..spt_values (1)  
   reads table master..sysdatabases (1)  
   read_writes table sybsystemprocs..sysattributes  
   calls proc sybsystemprocs..sp_getmessage  
      calls proc sybsystemprocs..sp_validlang  
         reads table master..syslanguages (1)  
      reads table master..syslanguages (1)  
      reads table sybsystemprocs..sysusermessages  
      reads table master..sysmessages (1)  
   reads table master..sysconfigures (1)