Help with TSQL please.

Is it the below query that you are looking for ?

     SELECT distinct a.loginname
         ,a.dbname
         ,a.dbrole
         ,b.serverrole
     FROM DBUser AS a
     JOIN ServerRole AS b
       ON a.loginname = b.loginname;
   GO

---

Regards, RSingh