SUSER_SID returns the SID of Windows domain user. I'm looking for a SID of the login created in the SQL Server that matches my domain group.

E.g.

Windows domain

user -> test\userA

domain group -> test\groupB

test\userA is a member of test\groupB

SQL Server

login -> test\groupB

SUSER_SID returns the SID of test\userA and I'm looking at ways to retrieve the SIF matching the specified on a server login (test\groupB)

Thanks,

Igor