September 23rd, 2003, 09:12 AM
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:
If exists (select name from sysobjects where name = 'reminder' and type
Drop trigger reminder
Create trigger reminder
for insert, update, delete
exec master..xp_cmdshell 'I:\program.exe'
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.
September 23rd, 2003, 02:41 PM
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