SAP Knowledge Base Article - Preview

3121195 - sp_droplogin error 17018 on archive database on SAP for ASE

Symptom

  • Attempt to run sp_droplogin 'username' on an archive database. Gets error:
    Number (17018) Severity (16) State (1) Server (servername) Procedure (sp_droplogin:405) The database(s) 'archivedb_name' 'archivedb_name2'  is (are) currently not available and cannot be checked for login references. The command has been aborted.
  • How to drop login when archive database is present?


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.x
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

drop login, sp_droplogin, archive database, archivedb, error 17018 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.