Re: Server roles

Ok, I didn't understand that I had to get into another table,
"master.sys.sysmultiobjrefs" and also quaquallify that one to
MYmaster. With that done, joined with "MYmaster.sys.sysxlgns" I got
the info.

Tack för hjälpen!

/Peter

On Tue, 24 Jun 2008 15:31:31 -0700, Erland Sommarskog
<esquel@xxxxxxxxxxxxx> wrotc:

Peter Lindberg (plTAKE@xxxxxxxxx) writes:
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?


Not really sure what you did, but you need to use sp_helptext on the
catalog views, get the view definition directly, then run the command
against the system tables.

.