trigger can not run application

Question

I want to create a trigger that activates the application, but it doesn't run, the error message: The specified event type (s) is / are not valid on the specified target object.

this code:

use test011
go
CREATE TRIGGER Record    ON  DATABASE    
AFTER INSERT
AS 
select * from u_RecordAllBEGIN    
EXEC master..xp_CMDShell 'C:\testjob.exe';
END
GO

Answer 1

Dup on SO. You can't create a DML trigger on a database and trying to start an application within a trigger is likely a doomed approach. 

Answer 2

Hi Scott

do you have any idea how to run exe file with triggers from sqlserver?

Answer 3

Hi om,

Please try to use below query to create a trigger and check whether it works.

use test011 go CREATE TRIGGER Record    ON  u_RecordAllBEGIN AFTER INSERT AS   EXEC master..xp_CMDShell 'C:\testjob.exe' GO

Please also refer below articles for more details about create trigger and xp_cmdshell commands.

CREATE TRIGGER (Transact-SQL)

xp_cmdshell (Transact-SQL)

Best regards,

Melissa

-------------------------------------------

MSDN Community Support

Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact [e-mail]

Answer 4

HI om,

Could you please provide any update about this error? 

Please help check whether the provided solution is working or not.Thanks.

Best regards,

Melissa

-------------------------------------------

MSDN Community Support

Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact [e-mail]