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 |
|
Kris N
Starting Member
2 Posts |
 Posted - 2014-09-26 : 16:48:13
|
| Hello allI am trying to track the root/process that created a mail log in the sysmail_mailitems table. This is for an automatic email that is generated when there is a change in a particular field in one of the tables on the sql server. I have already looked through the jobs and task scheduler, but found nothing related. And my IT Admin tells me there is only one sql server instance, ruling out my suspicion for a second. So my question is.. how do I figure out what caused it? Any other possibilities I can look up?If the question doesnt make sense or lacks information to troubleshoot, please let me know and I will try to provide more details. I am a newbie in this area and any help is sincerely appreciated.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-09-26 : 17:20:59
|
| Check for a trigger on the table. If you can't find anything, run a trace to capture the info.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Kris N
Starting Member
2 Posts |
Posted - 2014-09-26 : 17:33:04
|
| It was the trigger!! Tara, you are truly a Goddess! Thanks a ton. I am super glad I joined this forum :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Track sender location with mailitem
Tara Kizer