Can any1 help me in generating following output?? Plz provide script..
I want to collect following details,
Login_names,ServerLevel role,Database Level role,Databases associated for that role.
this means i need to capture all login names lets say if there r 3 logins A,B,C then
i want to capture their names,there server level roles and also details for which databases A is db_owner and for which databases it is dbreader.
It is too complicated but plz help me out.