launch client application from database trigger on MS SQL Server
Posted on 2004-08-28
I want to launch a client application from a database trigger on MS SQL Server. When a table is updated the rigger should launch an application that checks various things. Any Ideas how to do this? I tried by creating a DTS to launch a exe-file on the client computer. It did not work. Could not find path. I wonder if u can use DTS to launch an app remotely or should I use MSMQ. How is this done? I have never used MSMQ before.