I found it my issue. It seems the trigger generated thousands of emails, that ended up in my SQL unsent email table, and SQL was sending those. so even after i had dropped the trigger, there were still emails being sent from the unsent table. once i deleted those, my emails stopped coming. On that note, i am testing, and for each connection, it inserts 19 rows into my test table. I am going to start another post, for this issue.

Thanks,

Leonard