use master
go
sp_addlogin junk, 'junk'
go
exec pubs..sp_grantdbaccess junk
exec northwind..sp_grantdbaccess junk

go
sp_helplogins junk
go

exec pubs..sp_dropuser junk
exec northwind..sp_dropuser junk
exec sp_droplogin junk

output:
LoginName SID                                      DefDBName    DefLangName          AUser ARemote 
--------- ----------------------------------------------------- -------------------- ----- ------- 
junk      0xC2833AB7AE01E344A2EACA03AC9FDDD3       master       us_english           yes   no     

(1 row(s) affected)

LoginName DBName             UserName UserOrAlias 
--------- ------------------ -------- ----------- 
junk      Northwind          junk     User    
junk      pubs               junk     User