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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Track sender location with mailitem

Author  Topic 

Kris N
Starting Member

2 Posts

Posted - 2014-09-26 : 16:48:13
Hello all

I 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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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 :)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-26 : 18:08:43
Yay! Glad to help.



Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -