email | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


When a new row is added to a table I want to send an email to the user, can I do this by using sql DTS or is there any other way. Thanks!
"He laughs best who laughs last"
How about with a trigger?
Luis Martin
Moderator Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
I have no idea, with trigger how can i send a mail Thanks!
"He laughs best who laughs last"
That will create a performance contention on SQL process when there are many rows inserted by the application.
What is the reason behind having this facility for the user.
At the end of the day run a query for newer rows and extract information via DTS or your easy method and attach that file to send email via SQLagent. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.