I have a basic trigger that send an e-mail when a record is inserted in a table
based on a condition in another table.
For Example if the letter A is inserted in a column on Table A and the condition is met in table B the trigger execute and works fine.
However the problem is, when you try to insert again and the condition
above is met again it gives an error because the letter A is already in the table. How can you change it to e-mail everytime the above condition is met. Thanks
Absolutely NOT a good idea to have triggers sending out e-mails.
Use the trigger to populate a table that holds a queue of messages to be sent, and then have a SQL Server job scheduled to e-mail messages from the queue.
If it's not practically useful, then it's practically useless.