Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vikky
Yak Posting Veteran
54 Posts |
 Posted - 2012-06-25 : 05:52:46
|
| Hi,Please help on this.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.Is there any triggers to find the object name?Please help. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-25 : 06:07:07
|
| 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. |
 |
|
|
vikky
Yak Posting Veteran
54 Posts |
Posted - 2012-06-25 : 06:15:32
|
| Tank you for your fast replay.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.