T-SQL is not asynchronous, so you really have no choice but to wait until SP2 ends. Luckily, that’s what you want.
CREATE PROCEDURE SP1 AS
EXEC SP2
PRINT 'Done'
T-SQL is not asynchronous, so you really have no choice but to wait until SP2 ends. Luckily, that’s what you want.
CREATE PROCEDURE SP1 AS
EXEC SP2
PRINT 'Done'