Home Forums SQL Server 2008 SQL Server 2008 - General Track Updates in Quantity Field RE: Track Updates in Quantity Field

  • March 7, 2012 at 9:02 am

    #1456072

    Having a SQL trigger sending email when data is changed is not a good idea.

    However, you may still want to get email ASAP, faster than periodic job...

    You can follow the previous advise to create a trigger which audit the changes into another table. Then design a service which pools the table and sends emails...

    Beeing in SQL2008, instead of triggers you may be interesting to try in-built CDC (change tracking)

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]