Thanks a lot Sean.. That answers almost all the queries i had at this point of time.

Sean,

As of now, i have directly embedded the code to send the email to user in the trigger and am not calling a stored procedure..

Do you think it...

Thanks for the info Sean.

The trigger checks the count of records in the parent table. If the count is greater than a specified number; it sends an email to the...