SQL 2000 audit SP, VIEWS and Functions


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!!!



more ▼

asked Apr 15, 2012 at 06:42 PM in Default

avatar image

394 33 33 38

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Apr 16, 2012 at 07:36 AM

avatar image

Usman Butt
14.9k 6 13 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 15, 2012 at 06:42 PM

Seen: 981 times

Last Updated: Apr 16, 2012 at 07:36 AM

Copyright 2018 Redgate Software. Privacy Policy