Re: Server roles
- From: plTAKE@xxxxxxxxx (Peter Lindberg)
- Date: Mon, 23 Jun 2008 13:24:38 GMT
Uri, you are probebly right, but I believed it was possible. Damn
dynamic views;-)
The tricky part is that its for IA64 and I don't have any hardware.
I'll try it in a VMware VM, if the customer can't get the info by
digging deeper in there documentation.
/Peter
On Mon, 23 Jun 2008 15:48:34 +0300, "Uri Dimant" <urid@xxxxxxxxxxx>
wrotc:
Peter
Can you install another SQL Server instance and then restore master database
?
"Peter Lindberg" <plTAKE@xxxxxxxxx> wrote in message
news:48618acd.19203156@xxxxxxxxxxxxxxxxxxxxxxx
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: Erland Sommarskog
- Re: Server roles
- References:
- Server roles
- From: Peter Lindberg
- Re: Server roles
- From: Uri Dimant
- Re: Server roles
- From: Peter Lindberg
- Re: Server roles
- From: Uri Dimant
- Server roles
- Prev by Date: Re: Certificate Requirements for SQL Data Encryption
- Next by Date: Re: Grant v Deny
- Previous by thread: Re: Server roles
- Next by thread: Re: Server roles
- Index(es):
Relevant Pages
|
