The login that you are trying to drop is more than likely the owner of a database, or it exists as a valid user or alias in one of the databases.
You'll have to remove the user's access from all databases first before you attempt to remove the actual server login.
If the user is a user in a database, you should also get an error returned similar to this :
Server Message: Number 19587, Severity 16You might want to check out Rob Verschoor's "sp_rv_helplogin" from the procs at http://www.sypron****/new_ssp.html.
Server 'SYBASE', Procedure 'sp_droplogin', Line 281:
User exists or is an alias or is a database owner in 'nnn' database(s).
(1 row affected)
(return status = 1)
Edit: Mmm, it kept mangling the URL on posting - real one is www-dot-sypron-dot-nl-slash-new_ssp.html.