I need to start from a stored procedure on a root management engine, another engine that is not started at that time. I need that engine to run in its own memory space, without need for my procedure to wait until that engine stops. Just run and go, and my management engine terminate the procedure and move further.
Work-arround: I made an ODBC data-source with the option "start database if not running" checked, and "stop db after last disconect" not checked. It is not an acceptable solution for me. I'm looking for an "internal command" solution.
Note: using xp_cmdshell with, for instance, call xp_cmdshell('dbsrv6 ... d:\test.db') is not a solution, because the procedure waits for that new-started engine to stop
Work-arround: I made an ODBC data-source with the option "start database if not running" checked, and "stop db after last disconect" not checked. It is not an acceptable solution for me. I'm looking for an "internal command" solution.
Note: using xp_cmdshell with, for instance, call xp_cmdshell('dbsrv6 ... d:\test.db') is not a solution, because the procedure waits for that new-started engine to stop