This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The IsNTGroupMember method exposes an instance of Microsoft SQL Server access rights for Windows user accounts.
Use the IsNTGroupMember method to discover access rights for a Windows user when login access is granted to Windows group accounts.
When a Windows security account is granted or denied access to an instance of SQL Server, an entry exists in syslogins. The SQL Distributed Management Objects (SQL-DMO) Logins collection will expose a member referencing the security account. When a syslogins record, or Login object, references a Windows group account, individual records and objects are not created referencing group members.