sp_unbindcache_all

Unbinds all objects that are bound to a cache.

sp_unbindcache_all cache_name

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.

The permission checks for sp_unbindcache_all differ based on your granular permissions settings.

Granular permissions enabled	With granular permissions enabled, you must be a user with manage data cache privilege.
Granular permissions disabled	With granular permissions disabled, you must be a user with sa_role.

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	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect