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

Maripili gravatar image

394 32 33 35

(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][1] from Technet to help your cause according to your environment and needs.

[1]: http://technet.microsoft.com/en-us/library/dd277388.aspx
more ▼

answered Apr 16, 2012 at 07:36 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 875 times

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