
September 23rd, 2003, 09:12 AM
|
|
Junior Member
|
|
Join Date: Sep 2003
Posts: 2
Time spent in forums: < 1 sec
Reputation 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
|