Does anyone know how to tell from within SQL Server if a
connected user is a Windows Domain Admin? Thanks.You could possibly query AD using an ADSI linked server using an LDAP query
as described in BOL (Linked server section) but this would be a fair bit of
effort and its pretty slow
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"schumacr" <anonymous@.discussions.microsoft.com> wrote in message
news:001401c3a2f6$b8b85ad0$a401280a@.phx.gbl...
Does anyone know how to tell from within SQL Server if a
connected user is a Windows Domain Admin? Thanks.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment