sp_helpsrvrolemember

johndoe_at_driver.net
Date: 10/28/04 

Date: Thu, 28 Oct 2004 03:20:14 -0500

Currently I am using sp_helpsrvrolemember to retrieve all of the users and
their appropriate roles. Then I use a filter to grab an individual user. I
am wondering if there is something I am missing. I am looking for
(preferably) a sproc that takes a Windows/Sql Login and returns all of the
roles that the user is a member of.

    From what I have read sp_helprole, sp_helprolemember,
sp_helprsrvrolemember do not do what I need.Any help is appreciated.

Relevant Pages

  • Re: list all groups
    ... to filter on group objects instead of user objects. ... I retrieve and output ... Dim objCommand, objConnection, strBase, strFilter, strAttributes ... ' Filter on group objects. ...
    (microsoft.public.scripting.vbscript)
  • Re: list all groups
    ... to filter on group objects instead of user objects. ... I retrieve and output ... Dim objCommand, objConnection, strBase, strFilter, strAttributes ... ' Filter on group objects. ...
    (microsoft.public.scripting.vbscript)
  • Re: How do I get all column descriptions from a schema.table?
    ... To avoid this issue and only retrieve the column description, we can filter ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.framework.adonet)
  • Retrieve selected data from Network file
    ... I have a spreadsheet used by 100 ish people each ... The network connection ... I need to retrieve the data without opening file b. ... can filter the records using this method. ...
    (microsoft.public.excel.programming)
  • Retrieve value from closed workbook without using recordsets
    ... The sheet is large and a lot of information needs to be ... The first method I used was to open the workbook, ... and took about 4 - 5 mins to retrieve the ... filter the records. ...
    (microsoft.public.excel.programming)