SAP Knowledge Base Article - Preview

2614081 - Dropping database reports 3228 "Cannot drop this database...dropping the referenced database (dependent database). - ASE

Symptom

  • Running a drop database command
  • A 3738 error is reported

Server Message:  Number  3728, Severity  16
Server '<server>', Line 1:
Cannot drop this database '<database1>' as it has some dependencies (referential constraints) from database '<database2>'.  Drop the referencing database first, before dropping the referenced database (dependent database).

  • Error 2278 is also reported when running dbcc dbreboot

Server Message:  Number  2278, Severity  16
Server '<server>', Line 1:
Unable to shut down the database '<database1>' while making use of it.

  • sp_depends does not show any dependencies
  • The following query does not show any dependencies

select object_name(tableid), frgndbname
from sysreferences
where frgndbname is not null


Read more...

Environment

SAP Adaptiive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

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.