sp_bindcache cache_name, dbname [, [owner. ] tablename [, indexname |”text only'] ]
owner – optional if the table is owned by “dbo”.
To bind a database SALES to a named cache sales_cache, enter:
sp_bindcache 'sales_cache', 'SALES'
Cache binding is valid for the entire cluster. There is no instance-specific cache binding. If you bind an object to a local cache, the instance that has the cache configured for it uses that cache, and all other instances use the default data cache.
For complete documentation of sp_bindcache,
see the Reference Manual: Procedures.
