Wednesday, March 21, 2012

Need some help with a Triggers (FOR INSERT)

Hi there

I' d like to make a trigger which will come with some kind of message ( maybe jscript?) or printout, each time

I insert new client into the Client table. Clent table has ClientID, ClientName, Address, EMail, and ContactPerson.

Please help

M.D.

If you would like to send e-mail you can use dbmail, I think that Java script will not work inside SQL trigger, and remember that trigger should work as short as possible, because control will be returned to caller after trigger finish. The best will be to insert record to special table or mark record as to notify and run Job on SQL Job Agent to check records in the table periodically and send reports or print them. Insider job you can do more stuff like run SSIS package, call application and more

Thanks

JPazgier

No comments:

Post a Comment