I have an AFTER INSERT trigger on my MSSQL 2008 database table. Using
SSMS, I can insert and the trigger fires and all is fine.

If I use my DataContext, create an object, populate it, and
SubmitChanges() the row gets into the table but the trigger never
fires.

I need this trigger! Someone, please tell me how to get the DBML to
play nice with my trigger. Also, how can I see the TSQL that LINQtoSQL
is generating for the insert, maybe that will help me debug?


Thanks.