question

Maripili avatar image
Maripili asked

SQL 2000 audit SP, VIEWS and Functions

Hi! 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!!! Regards, Maripili
sql-server-2000audit
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
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
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.