December 31, 2008 at 3:24 pm
SQL Gurus:
What is the best method to trigger a periodic email when a certain row gets removed? I know I can add a trigger to the table, but I prefer not to since it's a vendors database. I'm thinking store procedure or job to check a couple of time a day.
Thanks and Happy New Year!
Dave
December 31, 2008 at 3:26 pm
If you want to avoid modifying the vendor's database, then that is your only choice.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 31, 2008 at 3:31 pm
I want to avoid modifing it but still want to read it.
December 31, 2008 at 3:40 pm
Yes.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply