Symptom
- When trying to drop a stored procedure, following error message is raised:
Msg 3708, Level 16, State 1
Server '<server_name>', Procedure <procedure_name>, Line <number>
Cannot drop the procedure '<procedure_name>' because it is currently in use.
-
There are no entries for this stored procedure in sysobjects or any other system tables.
-
Dbcc checkcatalog returns no errors.
- Following command returns at least one entry:
select * from master..monCachedProcedures where ObjectName= "<procedure_name>"
Read more...
Environment
SAP Adaptive Server Enterprise (ASE). Not version or platform specific.
Product
Sybase Adaptive Server Enterprise 15.0
Keywords
proc; sp; delete; remove; replace; batch; error 3708; message 3708 ; plan; proc cache; sybase; 3708 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This 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.