SQL Server 2005 Security Logins Audit
Posted on 2009-05-08
Windows 2003 Forest (x86)
Windows 2003/2008 server (x86 / x64) STD and ENT editions
SQL 2005 (x86 / x64) STD and ENT editions
Maybe straight forward but I am in need of getting a report together pretty soon..!
What I am looking to do is use an input file of server hostnames (SQL servers) and run an audit on all the sql security logins on each server (including local groups and domain groups) and have the membership of these group made into an audit report?
I could take an input file from .csv and then a dsquery but I was hoping to see if there are better methods to run within sql to achieve this in a more automated manner?
I appreciate any guidance/pointers on where I may start (and yes, I have already began research on EE and Google ;-)