I am using SQL Server 2012 and my database is set to 'SQL Server 2000 (80)' compatibility level.
I have a table called "FORMS" and I need that an email be sent every time I get an INSERT in the table.
The email should contains a couple record info including the auto generated key (this is very important). I already have the ASPX script to send the email and I suppose that if this is possible it should be done using a trigger, right?
Could anyone please help me with the details about how to do that?