Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-03 : 08:26:12
|
| Ravindra writes "I want to execute a VB application through a trigger written in MS SQL Server i.e. whenever records comes in database the trigger should be executed to run a particular application." |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-06-03 : 09:12:57
|
| Hi I would'nt suggest doing this for performance reasons, but you can use xp_cmdshell. Look it up in the Books online. I suggest you create a job to call the exe, and schedule the job to run a few seconds later from the trigger. That way it will be asynchronous, and the results of the execution of the application will not interfere with the INSERT/UPDATE.Owais |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-03 : 19:58:35
|
| Be advised that you cannot use xp_cmdshell to execute an application that has a user interface. It has to be something that runs and terminates without any user intervention whatsoever. The same applies to a job that runs the executable, you do not want to run an app that requires someone to close it manually. |
|
|
|
|
|
|
Triggering application through SP/Trigger