Poor man's SQL auditor.
The classic rhetorical question when diagnosing a technical issue "what changed on the server?", may now be possibly answered. Since some of my servers do not have Service Broker and Notification Services activated or installed, I had to come up with a solution that would work on my installed base of SQL 2005 as I originally intended to make this a Notification Services running asynchronously just a learning exercise.
Monitoring and Recording DDL changes on SQL 2005 (NARC) - SQL Server Central
No comments:
Post a Comment