list logins and server rolls

[bertieuk]

Can some kind person please tell me how I can list all logins, server roll membership and database permissions from the querry analyser.

Thanks

Si

 

[hmckillop]

if you execute the system stored proc
exec master..sp_helplogins
it might give you what you need.

"I'm living so far beyond my income that we may almost be said to be living apart