Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
Julian
Julian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>
|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who
> is
>
sql

Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who[vbcol=seagreen]
> is
>

Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > How Can I list the users in an NT group, ie I have user Joe Bloggs
who
> is
> > in NT Group Domain/Users.
> >
> > I need to return to a client app what group they are in.
> >
> > Julian
> >
> >
>

enterprise manager entries

I create SQL Server Groups in Enterprise manager and for
some reason and at what seems like random times they all
go away. I see a blank list under SQL Server Groups.
I checked the registry entry below and all SQL Server
Groups that I created are there.
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X\SQL Server
Group
With that information, is there a way to hook it back
together so what is in the registry is what is displayed
in enterprise manager for SQL Server?
Thanks
RickRick,
Strange!What service pack and OS are you on?
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rick Allison" <allisonrja@.hotmail.com> wrote in message
news:edc3f8oWDHA.2056@.TK2MSFTNGP11.phx.gbl...
> I create SQL Server Groups in Enterprise manager and for
> some reason and at what seems like random times they all
> go away. I see a blank list under SQL Server Groups.
> I checked the registry entry below and all SQL Server
> Groups that I created are there.
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> Group
> With that information, is there a way to hook it back
> together so what is in the registry is what is displayed
> in enterprise manager for SQL Server?
> Thanks
> Rick
>|||Dinesh,
I am running Windows XP and enterprise manager version 8.0. (at least
that's what is says in help about)
Does that help?
Rick
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uZ6mdGpWDHA.1744@.TK2MSFTNGP12.phx.gbl...
> Rick,
> Strange!What service pack and OS are you on?
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> news:edc3f8oWDHA.2056@.TK2MSFTNGP11.phx.gbl...
> > I create SQL Server Groups in Enterprise manager and for
> > some reason and at what seems like random times they all
> > go away. I see a blank list under SQL Server Groups.
> >
> > I checked the registry entry below and all SQL Server
> > Groups that I created are there.
> > HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> > Group
> >
> > With that information, is there a way to hook it back
> > together so what is in the registry is what is displayed
> > in enterprise manager for SQL Server?
> >
> > Thanks
> >
> > Rick
> >
> >
>|||Rick,
Thanks but I need the service pack(sp) info. too to report this case in mvp
newsgroup.You can find the sp info by executing the below command in Query
Analyzer
SELECT SERVERPROPERTY('PRODUCTLEVEL')
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rick Allison" <allisonrja@.hotmail.com> wrote in message
news:%23umCGTpWDHA.1900@.TK2MSFTNGP10.phx.gbl...
> Dinesh,
> I am running Windows XP and enterprise manager version 8.0. (at least
> that's what is says in help about)
> Does that help?
> Rick
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:uZ6mdGpWDHA.1744@.TK2MSFTNGP12.phx.gbl...
> > Rick,
> >
> > Strange!What service pack and OS are you on?
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> > news:edc3f8oWDHA.2056@.TK2MSFTNGP11.phx.gbl...
> > > I create SQL Server Groups in Enterprise manager and for
> > > some reason and at what seems like random times they all
> > > go away. I see a blank list under SQL Server Groups.
> > >
> > > I checked the registry entry below and all SQL Server
> > > Groups that I created are there.
> > > HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > > Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> > > Group
> > >
> > > With that information, is there a way to hook it back
> > > together so what is in the registry is what is displayed
> > > in enterprise manager for SQL Server?
> > >
> > > Thanks
> > >
> > > Rick
> > >
> > >
> >
> >
>|||Rick,
Thanks.Can you try upgrading to SP3 or latest SP3a?the download is available
at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
The reason for my advice is , may be, its due to the slammer worm.More
details
http://www.microsoft.com/sql/techinfo/administration/2000/security/slammer.asp
Even if you report this error(or bug), the first suggestion would be to go
in for the latest service pack.So do a test of your app. in a test env. with
SP3(a) and if okay, then go for the same with prod.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rick Allison" <allisonrja@.hotmail.com> wrote in message
news:ObqkmvpWDHA.1872@.TK2MSFTNGP12.phx.gbl...
> Dinesh,
> The query returned - SP2
> Rick
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:OANx1WpWDHA.1900@.TK2MSFTNGP10.phx.gbl...
> > Rick,
> >
> > Thanks but I need the service pack(sp) info. too to report this case in
> mvp
> > newsgroup.You can find the sp info by executing the below command in
Query
> > Analyzer
> >
> > SELECT SERVERPROPERTY('PRODUCTLEVEL')
> >
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> > news:%23umCGTpWDHA.1900@.TK2MSFTNGP10.phx.gbl...
> > > Dinesh,
> > >
> > > I am running Windows XP and enterprise manager version 8.0. (at least
> > > that's what is says in help about)
> > >
> > > Does that help?
> > >
> > > Rick
> > > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > > news:uZ6mdGpWDHA.1744@.TK2MSFTNGP12.phx.gbl...
> > > > Rick,
> > > >
> > > > Strange!What service pack and OS are you on?
> > > >
> > > > --
> > > > Dinesh.
> > > > SQL Server FAQ at
> > > > http://www.tkdinesh.com
> > > >
> > > > "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> > > > news:edc3f8oWDHA.2056@.TK2MSFTNGP11.phx.gbl...
> > > > > I create SQL Server Groups in Enterprise manager and for
> > > > > some reason and at what seems like random times they all
> > > > > go away. I see a blank list under SQL Server Groups.
> > > > >
> > > > > I checked the registry entry below and all SQL Server
> > > > > Groups that I created are there.
> > > > > HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > > > > Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> > > > > Group
> > > > >
> > > > > With that information, is there a way to hook it back
> > > > > together so what is in the registry is what is displayed
> > > > > in enterprise manager for SQL Server?
> > > > >
> > > > > Thanks
> > > > >
> > > > > Rick
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Dinesh,
Okay - I'll go try.
I am, however, a developer in a large corporation and I use enterprise
manager to point to many different SQL Server databases, test and
production. Do I need to have each database updated or can I just update
enterprise manager that is loaded on my computer?
If I need to do each database, that is not a simple task. (sigh)
Thanks for all your help.
Rick
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:O%23FGn4pWDHA.3404@.tk2msftngp13.phx.gbl...
> Rick,
> Thanks.Can you try upgrading to SP3 or latest SP3a?the download is
available
> at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
> The reason for my advice is , may be, its due to the slammer worm.More
> details
>
http://www.microsoft.com/sql/techinfo/administration/2000/security/slammer.asp
> Even if you report this error(or bug), the first suggestion would be to go
> in for the latest service pack.So do a test of your app. in a test env.
with
> SP3(a) and if okay, then go for the same with prod.
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> news:ObqkmvpWDHA.1872@.TK2MSFTNGP12.phx.gbl...
> > Dinesh,
> >
> > The query returned - SP2
> >
> > Rick
> >
> > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > news:OANx1WpWDHA.1900@.TK2MSFTNGP10.phx.gbl...
> > > Rick,
> > >
> > > Thanks but I need the service pack(sp) info. too to report this case
in
> > mvp
> > > newsgroup.You can find the sp info by executing the below command in
> Query
> > > Analyzer
> > >
> > > SELECT SERVERPROPERTY('PRODUCTLEVEL')
> > >
> > >
> > > --
> > > Dinesh.
> > > SQL Server FAQ at
> > > http://www.tkdinesh.com
> > >
> > > "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> > > news:%23umCGTpWDHA.1900@.TK2MSFTNGP10.phx.gbl...
> > > > Dinesh,
> > > >
> > > > I am running Windows XP and enterprise manager version 8.0. (at
least
> > > > that's what is says in help about)
> > > >
> > > > Does that help?
> > > >
> > > > Rick
> > > > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > > > news:uZ6mdGpWDHA.1744@.TK2MSFTNGP12.phx.gbl...
> > > > > Rick,
> > > > >
> > > > > Strange!What service pack and OS are you on?
> > > > >
> > > > > --
> > > > > Dinesh.
> > > > > SQL Server FAQ at
> > > > > http://www.tkdinesh.com
> > > > >
> > > > > "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> > > > > news:edc3f8oWDHA.2056@.TK2MSFTNGP11.phx.gbl...
> > > > > > I create SQL Server Groups in Enterprise manager and for
> > > > > > some reason and at what seems like random times they all
> > > > > > go away. I see a blank list under SQL Server Groups.
> > > > > >
> > > > > > I checked the registry entry below and all SQL Server
> > > > > > Groups that I created are there.
> > > > > > HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > > > > > Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> > > > > > Group
> > > > > >
> > > > > > With that information, is there a way to hook it back
> > > > > > together so what is in the registry is what is displayed
> > > > > > in enterprise manager for SQL Server?
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > > Rick
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>