Re: Server roles

From: "Uri Dimant" <urid@xxxxxxxxxxx>
Date: Mon, 23 Jun 2008 13:40:07 +0300

SELECT *
FROM sysmembers membs
JOIN sysusers users on membs.memberuid = users.uid
JOIN sysusers groups on membs.groupuid = groups.uid

"Peter Lindberg" <plTAKE@xxxxxxxxx> wrote in message
news:485f6dcb.11777531@xxxxxxxxxxxxxxxxxxxxxxx

I have an old master database, I can restore it with another name but
it can't replace the real master.

Is there any way I can se the info about server roles from this
database? I want to se which "role members" there is for different
server roles?

/Peter

Follow-Ups:
- Re: Server roles
  - From: Peter Lindberg
- Re: Server roles
  - From: Peter Lindberg

References:
- Server roles
  - From: Peter Lindberg

Prev by Date: Server roles
Next by Date: Re: Server roles
Previous by thread: Server roles
Next by thread: Re: Server roles
Index(es):
- Date
- Thread

Relevant Pages

Re: Server roles
... Can you install another SQL Server instance and then restore master database ... JOIN sysusers groups on membs.groupuid = groups.uid ... Is there any way I can se the info about server roles from this ...
(microsoft.public.sqlserver.security)
Re: Server roles
... but with result from another master. ... JOIN sysusers users on membs.memberuid = users.uid ... JOIN sysusers groups on membs.groupuid = groups.uid ... Is there any way I can se the info about server roles from this ...
(microsoft.public.sqlserver.security)