sp

[farshad]

Hi,
Currently I am using a stored procedure and when it is finished I will then start a vb.net application manually to complete tasks.
This as you see involves two steps. One to run the SP and the second to run the vb.net application.
I am thinking of strating the vb.net application from the SP. Something like a sql that will run at the end of the SP and will start the vb.net applicatiion or process.
The question is should I use a windows service or a simple application in .net and then call it from the end of the SP or can you recommend anything else?

Thanks

 

[Robby]

Is a .Net app going to start the SP? If so, then why not allow that same app to start the main/other .net app?