Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Group login members

Author  Topic 

jmalathirao
Starting Member

9 Posts

Posted - 2008-02-20 : 14:42:42
Hi All,

'SACCAP\RiskGroup' is my group login which has few users.
Now i want to know all users in this group. For this i am using
EXEC sp_helprolemember 'SACCAP\RiskGroup'.

But no luck.

Can any one help me in this.

Thanks.
Malathi.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-20 : 14:59:45
Ask you NT guys( Windows). They have information about users inside the group.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-21 : 15:32:48
Try this:

xp_logininfo 'SACCAP\RiskGroup','MEMBERS'
Go to Top of Page
   

- Advertisement -