July 13, 2006 at 7:52 am
On the production server is there a way to track the NODE/IP for users that delete a row from the table, at SQL Server level so one can track updates application based or manual updates.
TIA
July 13, 2006 at 3:32 pm
The only real way to audit deletes would be to set up an audit table and use the DELETE trigger to populate it based off of the sysprocesses data. You could use Profiler, but the additional overhead and the storing/searching of trace files makes this option less than ideal. See this link for a good example of an auditing table. This article is geared towards auditing DTS packages, but the method will work great for your purpose (except for the fact that sysprocesses will not give you the IP address of the host, it will give you the NIC card's MAC address).
http://www.sqlservercentral.com/columnists/hji/auditingdtspackages.asp
July 14, 2006 at 12:45 am
You can use c2 Audit
http://www.sqlservercentral.com/columnists/dasanka/basicsofc2auditing.asp
There are third party tools for this task
SQL Apex SQL Audit and Red-Gate also has a tool
My Blog:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply