Is there anyway to audit a SQL table where you can get information such as what application is writing to it and when it writes to it?
There are a bunch of applications users are using here and I have combed through each on and cannot find where any of them write to this one table in SQL Server. And it's an important table.
It's driving me crazy.
You have to set up auditing from the start (usually through triggers that write to audit tables that include the user or application that is writing to the table). There is no way to find this information for past data if you did not have auditing designed into your system.
When you set up the audtitables you might want to include fields that are populated by these system variables:
suser_sname(), host_name(), app_name(), getdate()