I have one absentees table. From some where data getting inserted into absentees table. I am unable to find the source for that data insert.
Is there any way to get from which source data inserting.
1.Data inserted daily morning 6'o clock but there is no jobs are scheduled. 2. coding Developers said there is no services available to insert data into table.
Try the profiler - or yoou could use a trigger to the table to log what's happening. You will only get what information the source exposes though.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
But I am unaware to find the trigger log information. If i create the DML Trigger on absent table how to find the source for data either SP/Service/Job.
Note : All recods inserted into Absentees table with column createdby with -1.
How to find the source for table data insert.
Posted - 06/25/2012 : 05:52:46
