When trying to bind a user created cache to a database getting the following errors:
1> sp_bindcache <dbname>_cache,<dbname>
Msg 857, Level 16, State 1:
Server 'svrname', Procedure 'sp_bindcache', Line 414:
Command Failed: Cannot bind or unbind database '<dbname>' to or from a cache as it is currently in use. If it is a user created temporary database, it is considered to be in use if some session is assigned to it. Refer to the users manual for more detail.
Msg 19828, Level 16, State 1:
Server 'svrname', Procedure 'sp_bindcache', Line 421:
Cache binding failed for database '<dbname>'.
(return status = 1)
SAP Adaptive Server Enterprise (ASE) 16.0
sp_bindcache command , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.