sp_bindcache assigns a database, table, index, text object, or image object to a cache. Before you can bind an entity to a cache:
The named cache must exist, and its status must be “Active.”
The database or database object must exist.
You can bind tables, indexes, or objects only from the database where they are stored.
To bind system tables, including the transaction log table syslogs, the database must be in single-user mode.
You must bind a database from the master database.
You must bind a database, user table, index, text object, or image object to a cache of type “Mixed.” Only the syslogs table can be bound to a cache of type “Log Only.”
To bind an object to a cache, you must own the object or the database, or have system administrator status.
Binding objects to caches is dynamic.
Cache binding or unbinding for local system temporary
databases is not dynamic, and the owner-instance must be restarted
for the bindings to take effect. Cache binding or unbinding for
other temporary databases, including the global system temporary
database, are dynamic.
