#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0

    Sql trigger locks table


    I have set up a trigger to notify me when someone updates a table. We run SQL 7, but our parent company recently switched us to Lotus notes, so we lost the sql interface via exchange, and email notifications. I have written a .net program to take care of this, and it worked fine until I included a query on the table that was firing the triggers. I have tried putting a waitfor statement in my trigger, but that doesnt work. whenever the trigger fires, it keeps a lock on the table, but so does the vb program that the trigger kicks off.

    The trigger looks like this:

    Use db
    If exists (select name from sysobjects where name = 'reminder' and type
    ='TR')
    Drop trigger reminder
    go
    Create trigger reminder
    on table
    for insert, update, delete
    as

    exec master..xp_cmdshell 'I:\program.exe'
    go

    This is the original trigger, until I added a query in the program.exe everything worked fine. once I queried the table from the program the problems started.
    Thanks.
    Bill
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0
    I'm sorry I don't have an answer to your question, but from the sound of your situation, you might have some insight into an issue of mine... Could you take a look at my post if you have a chance? http://forums.devshed.com/t86105/s.html

    Thanks!

IMN logo majestic logo threadwatch logo seochat tools logo