Hi to all
I have created a trigger to call a program that is written by our program. The program is basically read the record in the table and write to a text file, then delete the record from the table.
The trigger is a after insert trigger. After we added the trigger, we insert a record to the table. The result is that the record still and did not get deleted. Also, the text file didn't get created either. It seems that it take a long time for the record to be written to the table.
But if we just run the program (a exe file), it can write a text file in the folder and delete the record. the trigger is basically:
/****** Object: Trigger [dbo].[ZinterProcess] Script Date: 04/29/2014 18:34:56 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
create trigger [dbo].[ZinterProcess] on [dbo].[Zinter]
execute master.dbo.xp_cmdshell 'start C:\ZinterProcessor\ZinterProcessor.exe'
Any idea or help will be greatly appreciated.