Re: Server roles

From: plTAKE@xxxxxxxxx (Peter Lindberg)
Date: Mon, 23 Jun 2008 11:38:57 GMT

What I want to do is

EXEC sp_helpsrvrolemember 'securityadmin'

but with result from another master.

/Peter

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

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: Uri Dimant

References:
- Server roles
  - From: Peter Lindberg
- Re: Server roles
  - From: Uri Dimant

Prev by Date: Re: Server roles
Next by Date: Re: Server roles
Previous by thread: Re: 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
... JOIN sysusers groups on membs.groupuid = groups.uid ... it can't replace the real master. ... Is there any way I can se the info about server roles from this ...
(microsoft.public.sqlserver.security)