July 23, 2013 at 12:38 pm
I have one SQL Server table (one of many) that night will be filled. Nobody knows which program, service or whatever fills this Table every Night.
Is there a quick way to find out when and where insert/update into this table? (many jobs, many tables, stored procedures and many many linked servers).. of course search-routine, profiler, watch interfaces ???
I am new in this Company, and nobody can give me Feedback about this. :w00t:
kind Regards
Nicole
July 23, 2013 at 1:01 pm
Without either audit triggers or traces in real time, modifications are going to be hard to audit. That data is not kept by the system without some setup. If you have some idea of the time you could look at the job history and see what is running around that time..
CEWII
July 23, 2013 at 1:15 pm
Try running Profiler during the hours that the tables get filled.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 23, 2013 at 1:30 pm
Alvin Ramard (7/23/2013)
Try running Profiler during the hours that the tables get filled.
This would be my go-to if I didn't have an audit server setup for the database. It's not a very pretty approach, but if you're willing to read logs it'll let you know at the very least who's running inserts.
July 23, 2013 at 3:50 pm
I would add an INSERT trigger that captures app_name(), host_name(), SYSTEM_USER, USER and sysdatetime() to a log table.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 24, 2013 at 4:53 am
+1 for the trigger solution.
If you are still in your probation period at this new company, remember that the assessment goes both ways ! :w00t:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply