Re: Server roles

I got the info by starting a virtual server with the old mdf and ldf
files.

But Erland, your thought was clever, pity I couldn't get it to work;-)
I could get data from "MYmaster.sys.sysxlgns". All other "sys.sys*"
gave me the same result if I prefixed it with master or MYmaster.

It's probebly my poor t-sql. Is it possible to create a query that
would actually give the output result as I would get it from
sp_helpsrvrolemember?

/Peter



On Mon, 23 Jun 2008 15:26:24 -0700, Erland Sommarskog
<esquel@xxxxxxxxxxxxx> wrotc:

Peter Lindberg (plTAKE@xxxxxxxxx) writes:
Uri, you are probebly right, but I believed it was possible. Damn
dynamic views;-)

Here is what you can do. First log in directly on the server machine.
Then connect to SQL Server with ADMIN:(local). This connects you on
the DAC, Dedicated Admin Connection.

Then do

sp_helptext 'sys.server_principals'

to get the query text for that view and copy it. You will find that
the view refers to the master database. You will also find that it
uses some special functions that will give you errors. Just comment
these.

From the DAC you can query the system tables directly. Note that this is
something you would do only exceptionally, but this is an exceptional
case.

Beware that you should not stay connected the DAC for any longer period,
as the DAC is intended to be a connection where the DBA can log in, when
the server is in a mess, and nothing else works. There is only one
connection possible through the DAC.

.

Relevant Pages

  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot connect client to server 2003
    ... you need to reconfigure the IP schema of your SBS ... On the SBS 2003 Server open the Server Management console. ... On the Connection Type page, click Broadband, and then click Next. ... Alternate DNS server, type the IP addresses that are provided by your ISP ...
    (microsoft.public.windows.server.sbs)
  • Re: Outgoing POP3 email missing/lost/not received
    ... ISP's mail server instead of the domain name on the ... SUMMARY OF SETTINGS FOR CONFIGURE E-MAIL AND INTERNET ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Networking Question - VLANs on SBS 2003 Premium SP1
    ... port on the old router so I now have a segregated WLAN. ... be sure you do not enable any DHCP server in internal network. ... On the Connection Type page, click Broadband, and then click Next. ... On the Network Connection, You must enable and configure the network ...
    (microsoft.public.windows.server.sbs)
  • Re: Still cant connect to RWW or OWA remotely
    ... it certainly appears to be something about the SBS configuration. ... Meridian.local Ethernet adapter Local Area Connection: ... Windows SMALL BUSINESS SERVER 2003 Windows IP Configuration ... 192.168.254.254) directly to a port on the router and then ...
    (microsoft.public.windows.server.sbs)