Hi,

I think that u must program a stored procedure that send mail after configuring sql mail through mai profile.

then depending on ur DTS schedule ur procedure.

Mail me for further discussion...

Hi.

Yes u can achieve this.

What I wld like to suggest u is that use this statement as the statement before u r firing the update query.

alter table tablename disable trigger...

Hi,

Well I did the same in my database.

If u want to perform this on every insert then it will be very tedious as it will require a lots of processing....