I see. I can use xp_logininfo to get to the login used for the session, thanks!

Do you know how bad is the performance? Original implementation was retrieving this info from...

See inline in code section

Paul White NZ (4/3/2010)

---

isakhnov (4/3/2010)

---

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...

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...