Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sonnysingh
Starting Member
42 Posts |
 Posted - 2005-05-12 : 09:19:00
|
| Hi FolksI have this query for user and roles from sysuers and sysmember table.. i want user name will be in separate column and roles in separate coulmn means two columns by running same query..Please help....SELECT a.nameFROM db_2_3.dbo.sysusers a INNER JOIN db_2_3.dbo.sysmembers b ON a.uid <> b.memberuidWHERE (a.name NOT LIKE 'db%') AND (a.name NOT IN ('guest', 'public'))Thanx in advanceSqlIndia |
|
|
|
|
|
Users and Roles list out from one query ..