Does MSSQL 2000 and above have an auditing feature? We have a requirement for tracking activity and history on a particular table. I realize this can be accomplished by a simple trigger but I was wondering if MSSQL had a feature that would accomplish this.
joeTriggers can record inserts, updates, and deletes, but not reads (selects).
You either need to log this activity through stored procedures used to access the data, or turn on SQL Profiler.|||Nope, you need a trigger
http://weblogs.sqlteam.com/brettk/archive/2004/10/20/2242.aspx
No comments:
Post a Comment