Try running
exec sp_helplogins
- although from memory you may have to have sysadmin permissions yourself to run it.
Failing that, there are tables in the
master database that contain the info you need ... something like this might work (but you may need to tweak it - I don't have SQL2000 to test it on)
use master
select * from syslogins
[EDIT - I should have looked here first ...]
list user permissions sql 2000 [
^]
Submit an article or tip