Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Unanswered: I must creat a Alert

    Hi,

    I must create (with sql Server 2000) a alert wich notify me if a transaction has exceed a precise interval of time (30 sec).

    How can i do?

    Thanks
    Andrea

  2. #2
    Join Date
    Aug 2002
    Posts
    20
    Hi Andrea


    With T-sql you have use @@spid, then save data from sp_who2 in a temporary table with a cursor. Use a count variable in your cursor and when that value becomes big enough your transaction has been going to long and now you can raierror….

    /Mada

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •