Was wondering if anyone knows how to run an application from the query analizser?
Eventually it would be a trigger that on insert it would startup an application that would take the record from the SQl server and start working with it.
In the past as developers we have just setup an application that would fire a SQL command off to SQL every x seconds until there was a new record to work with. The problem with that is the ammount of hits sql would take and the memory needed to keep the application runing.
Any one have any ideas
Eventually it would be a trigger that on insert it would startup an application that would take the record from the SQl server and start working with it.
In the past as developers we have just setup an application that would fire a SQL command off to SQL every x seconds until there was a new record to work with. The problem with that is the ammount of hits sql would take and the memory needed to keep the application runing.
Any one have any ideas
