2470874 - Unable to drop login with alias - SAP ASE

• Unable to drop login with alias to dbo in a database and owning objects
• Error(s) raised when trying to drop login that still owns object via alias:
  sp_droplogin mylogin
  go
  Msg 19587, Level 16, State 1:
  Server 'ASE', Procedure 'sp_droplogin', Line 376:
  User exists or is an alias or is a database owner in 'db_name' database(s).
  

  drop login mylogin
  go
  The login 'mylogin' is still a user, alias or database owner in 'db_name' database.
  Msg 3770, Level 16, State 1:
  The DROP login 'mylogin' failed. See previous messages for more information.

  sp_dropalias mylogin
  go
  Msg 18790, Level 16, State 1:
  Server 'ASE', Procedure 'sp_dropalias', Line 204:
  You cannot drop the alias for login 'mylogin' because 'mylogin' owns objects in the database.
  (followed by listing of objects owned)
  name                               type
  -------------------------------   -----
  abc                                  U

SAP Adaptive Server Enterprise (ASE)

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To