Any ideas about this? RRS feed

  • Question

  • HI experts, am having some doubts regarding alerts in sql server 2008..
    First of all  i will insert some records into sql server 2008, each time  a new record is inserted with
    status 0.Now we should update this status to '2' in two hours.otherwise an alert should be raised that particular row 
    has not been updated by 2 hours?and this should send a mail.

    How can i do this?

    can this be achievable in sql server or so how can I?
    • Moved by Bob Beauchemin Monday, October 4, 2010 2:46 PM Moved to a more relevent forum (From:.NET Framework inside SQL Server)
    Thursday, September 30, 2010 5:02 AM

All replies