Error 3702

Severity

16

Message text

Cannot drop the %S_MSG '%.*s', because it is currently in use.

Explanation

This error occurs when Adaptive Server tries to drop a database, user table, procedure, rule, default, trigger, or view that is currently in use.

Error 3702 can occur during:

Error 3702 can occur for the following reasons:

Action

Use sp_who to determine whether the database or object name in your drop command is currently in use. If it is in use, contact the user shown in the sp_who output.

If the process using the object was abnormally terminated (for example, with an operating system kill command), the object may not have been completely removed from the Adaptive Server system tables. The process would remain invisible while keeping the object open and in use. This prevents the drop command from succeeding. In this case, shutting down and restarting Adaptive Server should clear the 3702 error. After you restart Adaptive Server, run dbcc checkcatalog to determine whether corruption has occurred.

If you are trying to drop a database that contains keys currently used to encrypt columns in other databases, the command will fail. Before dropping the database containing the encryption keys you must first remove the encryption or drop the database containing the encrypted columns.

If error 3702 persists, call Sybase Technical Support.

Additional information

Before calling Sybase Technical Support, have the information available that is listed in “Reporting errors”, including the output of dbcc checkdb, dbcc checkcatalog, and dbcc checkalloc for the database that contains the object named in the error message.

Versions in which this error is raised

All versions