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.
| Author |
Topic |
|
honey_191
Starting Member
49 Posts |
 Posted - 2008-05-13 : 13:51:56
|
| How to find out all the members for a particular login group? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-13 : 14:07:28
|
| Why are you unable to find these things in SQL Server Books Online? It takes me about 30 seconds to find these for you. How long does it take to post a question here?sp_helprolemember 'RoleName'Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-05-13 : 21:30:03
|
| I think sp_helprolemember 'rolename' displays the members of that role in a particular database.It won't display all the login members of a particular login group.What is ur question honey_191??Do you need how to find out all the windows login accounts of a particular login group?? |
|
|
|
honey_191
Starting Member
49 Posts |
Posted - 2008-05-13 : 21:42:45
|
| I can able to find in sys.server_principals system table in 2005.But my problem is my server is on 2000.there is no system table like sys.server_principals.In that case how can i find the windows login members from a particular windows group.I googled alot,I didn't find anything.can anybody help me please? |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-14 : 10:09:26
|
| Short of creating an external stored procedure for the specific task, it is not possible to determine what Windows accounts are included in a Windows group from SQL Server, whether that group has access to SQL Server or not. You will need to talk to your Domain Administrators to view the membership of a Windows group. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-14 : 12:54:04
|
quote:
Originally posted by honey_191
I can able to find in sys.server_principals system table in 2005.But my problem is my server is on 2000.there is no system table like sys.server_principals.In that case how can i find the windows login members from a particular windows group.I googled alot,I didn't find anything.can anybody help me please?
Why did you post in a SQL Server 2005 forum then?!Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-14 : 22:31:10
|
| Use this:xp_logininfo 'nt group name','MEMBERS' |
|
|
|
|
|
|
Group