SAP Knowledge Base Article - Preview

2342483 - Msg 3708: Cannot drop the procedure '...' because it is currently in use. -SAP ASE

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.