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:

• A drop command such as drop database, drop table, drop procedure, or drop rule

• A dbcc dbrepair (database_name, dropdb) command

Error 3702 can occur for the following reasons:

• The object you are trying to drop is in use

• The process using the object was abnormally terminated

• Data corruption has occurred

• An Adaptive Server problem occurred

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