[dba-SQLServer] Finding current login group

Francis,

That is my intention but how do I get the recordset from the sproc.  The 
following doesn't work -

SELECT Permission_Path FROM master..xp_logininfo

Error message is "Invalid object name 'master..xp_logininfo'."

David

At 6/07/2004, you wrote:
>David,
>
>Anything wrong with the normal method of creating a temporary table
>to hold the stored procedure results and then selecting what you want?
>
>Francis R Harvey III
>WB 303, (301)294-3952
>harveyf1 at westat.com
>
>
> > -----Original Message-----
> > From: dba-sqlserver-bounces at databaseadvisors.com
> > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf
> > Of David Emerson
> > Sent: Tuesday, July 06, 2004 12:59 PM
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: RE: [dba-SQLServer] Finding current login group
> >
><snip>
> > Now, how do I
> > change the sproc so that it returns the value of the
> > permission path column?
> >
> > David
><snip>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com