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.