I was looking for some script or something to do an audition of all SPs, VIEWs and Functions in a DB in SQL 2000. (UPDATE, DELETE, INSERT -> USER, HOSTNAME, DATE, TIME) I know that for the tables we can use some triggers but i couldn't find some information for the other objects.
Do you know how can I audit this objects? I need it really asap.
Thanks a lot for your answer's!!!
For that I guess you have two choices. C2-level Auditing and Server side Traces. I would prefer Server side traces because you can choose exactly which events to audit and what information about each event to record. But there are some important considerations to keep in mind for both. I would recommend this article from Technet to help your cause according to your environment and needs.
answered Apr 16, 2012 at 07:36 AM