I've been tasked with a security audit for what will be 4 or 5 production servers. I can login to each on manually but have access to a really great fun sysadmin guy who will help automate the script.
These are all mixed authentication models:
I'm looking for a script ideas to audit * Server roles * Logins * Object permissions
for each instance. In case it's not obvious, I've mostly been a developer on SQL 2000/05 and the admin side is a learning curve.