Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jarthda
Starting Member
10 Posts |
 Posted - 2013-02-01 : 13:18:17
|
| 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 permissionsfor 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.Thanks everyone!JJarthdaEmbarcadero/SQL Server/and now... Informatica |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-08 : 18:36:31
|
| Use sqlcmd to automate the scripts and store the results in csv.It can connect to all prod server and get the information from all servers, stores it in csv; |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
Security Audit