Using sql-server: Launch multiple stored procedures to run ‘in the background’ on SQL Server Express Edition on newest questions tagged sql-server – Stack Overflow

Is it possible to run multiple stored procedures that run ‘in the background’?

The stored procedures must be launched from a single, master stored procedure, in the same way that multiple worker threads are spawned. For example:

CREATE PROCEDURE MyLauncher
AS
BEGIN
    BEGIN
      @EXEC MyBackgroundSP01 -- Runs in parallel to the other 2
      @EXEC MyBackgroundSP02 -- Runs in parallel to the other 2
      @EXEC MyBackgroundSP03 -- Runs in parallel to the other 2
    END
END

See Answers


source: http://stackoverflow.com/questions/1681906/launch-multiple-stored-procedures-to-run-in-the-background-on-sql-server-expre
Using sql-server: using-sql-server



online applications demo