Re: Server roles

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




.

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: Remove Exchange
    ... Make sure all the server roles have been transferred including routing ... public folders. ... > Master Exchange server, Now ...
    (microsoft.public.exchange.admin)
  • Re: Taking over Operations Master / DC roles
    ... > that with the exception of the Single Master Roles." ... my gameplan is to get the server updated and all info copied... ... Get the DNS setup and all my other odds and ends to the point that they are ... >> mapped install directory, and a time server. ...
    (microsoft.public.win2000.active_directory)
  • Re: Get Segmentation Fault when Building Sybase
    ... Doing ldd on the dataserver executable reveals that linux-gate is being used on 32 bit systems for system calls, but not on 64 bit, so any dodgy calls would be handled better on the 64 bit system. ... Building Adaptive Server 'LOCALHOST': ... Building master device... ... No external security mechanisms will be supported. ...
    (comp.databases.sybase)
  • Re: Disaster Recovery Plan
    ... preferable to restoring a master tape, ... Server and a HP tape drive. ... Attend a course taught by an expert instructor with years of in-the-field ...
    (Security-Basics)