Re: Check if user is a NT Group

From: Russell Fields (rlfields@sprynet.com)
Date: 08/30/02 

From: "Russell Fields" <rlfields@sprynet.com>
Date: Fri, 30 Aug 2002 08:11:13 -0400

Depending on the SQL Server version you are running, there are a couple of
useful commands:
IS_MEMBER
IS_SRVROLEMEMBER

Check these out.
Russell Fields
"John" <john_w_john2001NOSPAMNOSPAM@yahoo.com> wrote in message
news:OymHrb#TCHA.2516@tkmsftngp10...
> How do I check if a user is a group on the local machine?
>
> I have SQLServer running on machine A. I am able to add users from the
> DOMAIN (including groups). If I query syslogins it show me the groups as
> "DOMAIN_NAME\GROUP" and the flag "isntgroup" is 1.But if I add a local
group
> (those that exist on machine A), these dont show up as ntgroups....any
idea
> how to find this out?
>
> Thanks in advance,
>
>
>

Relevant Pages

  • Re: how to keep the DTS layout
    ... >Moving in and out of ActiveX invalidates yor layout. ... ...but depending on what you required you may be able to use a direct ... Transferring DTS Packages ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Converting from JET database to a true C/S Database
    ... Depending upon how large your database will be, and how many users are going ... This is the "FREE" version of MS SQL Server ... Depending upon your architecture you may be able to just point your application ... it is highly unlikely a database 'upgrade' is going to ...
    (microsoft.public.vb.general.discussion)
  • Re: Licensing Info
    ... You need an SQL licence for every user/device (depending on licencing mode) that derives information from the SQL Server. ...
    (microsoft.public.project)
  • Re: Time Left on SQL2000 Evaluation
    ... created on install) It's in the C:\WINNT (or C:\WINDOWS depending on OS) ... Jasper Smith (SQL Server MVP) ... "Jeff Dillon" wrote in message ...
    (microsoft.public.sqlserver.setup)