When sp_droplogin is unable to drop a login due to the existence – in any databasee – of a user in sysusers referencing the login suid, the names of databases in which the references are found are now displayed in the error message. The error message looks similar to:
1> sp_droplogin probe 2> go Msg 19587, Level 16, State 1: Procedure 'sp_droplogin', Line 281: User exists or is an alias or is a database owner in 'master' 'sybsystemdb' database(s). (return status = 1)