Unbinds all objects that are bound to a cache.
sp_unbindcache_all cache_name
is the name of the data cache from which objects are to be unbound.
Unbinds all databases, tables, indexes, text objects and image objects that are bound to pub_cache:
sp_unbindcache_all pub_cache
When you unbind entities from a cache, all subsequent I/O for the cache is performed in the default cache.
To unbind individual objects from a cache, use the system procedure sp_unbindcache.
You cannot use sp_unbindcache_all if the system tempdb is bound to pub_cache. If you do, you get an error message, and sp_unbindcache_all rejects the unbind for all objects.
Use sp_unbindcache to unbind the system tempdb first.
See sp_unbindcache for more information about unbinding caches.
Only a system administrator can execute sp_unbindcache_all.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
System procedures sp_bindcache, sp_helpcache, sp_unbindcache