2136018 - sp_drop alias reports Error 17231 "No login ... exists". Unable to drop alias when no login record exists -- SAP ASE

• Unable to drop alias when no login record exists
• A check of the sysalternates table and user names shows that some orphaned aliases exist in the database:
  
  1> select suser_name(suid), * from sysalternates
  2> go
                                  suid        altsuid
   ------------------------------ ----------- -----------
   myuser                                   7           1
   NULL                                   366          1
  
  
• Attempt to remove the orphaned alias fails:
  
  1> sp_dropalias NULL
  2> go
  
  Msg 17231, Level 16, State 1:
  Server 'SYBASE', Procedure 'sp_dropalias', Line 176:
  No login with the specified name exists.

SAP Adaptive Server Enterprise (ASE) 15.7

KBA , syslogins , orphaned , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem