2012 new database & login auditing
-
Morning all,
SQL 2012 Ent. I want a job to run that will alert me to the creation of new dbs, logins, and certain permission changes to logins. I can write my own checker & schedule but I'm wondering if you good people have a better way!
If not thank you.
-
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
-
Hello snomadj.
Take a look at SQLVER.
https://github.com/DavidRueter/SQLVer/blob/master/README.md
It's not fully auto, but changes are logged in tables and you can easily setup a job to email you the changes. Or a trigger to alert you when a new record is inserted in the SQLVER tables.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply