SQL Server 2000 trigger on insert -

SQL Server 2000 trigger on insert -

i need create trigger table contain millions of inserts.

that trigger send email (already done) me saying table beingness powered.

that email should send 1 time when insert starts (one day).

in other words, wanna :

create trigger on table t1 on first insert; exec procedure send email

not beingness developer don't know how write this...

thank you help.

you cannot on first insert trigger.

what this:

create normal on insert trigger sends email

at end of trigger, disable trigger:

alter table dbo.yourtable disable trigger yourtriggernamehere

this prevent trigger firing on , on 1 time again , sending tons of e-mail.

then, you'd need sql agent job @ night enable trigger 1 time again - fire 1 time again first insert of next day.

update: ok, in case be:

create trigger sendmail on mytable after insert exec master.dbo.myprocedure alter table dbo.mytable disable trigger sendmail

and in sql agent job @ night, you'd need:

alter table dbo.mytable enable trigger sendmail

sql-server triggers