On SQL Server 2008 R2 Management Studio, running a SQL command like:
EXEC Master..xp_cmdshell 'C:\path_to_my_winform_app.exe"
doesn't load my winforms app, says "executing query" but never runs my app.
I need to use SQL to run my own app, which is not a command line app, is a windows form app (.net framework).
How can get SQL Server to call my Winforms application's .exe file?
I tried making a .bat and a cmd file (.bat and .cmd) containing:
start "" "C:\my_winforms_app.exe"
exit
and calling the .cmd or .bat file using:
EXEC Master..xp_cmdshell 'C:\path_to_my_caller.cmd"
EXEC Master..xp_cmdshell 'C:\path_to_my_caller.bat"
Still show the same "executing query" but never ends, and my windows form app is never opened
How can I do that?