EXEC sp without return (EXEC @Results = sp)
EXEC spwho2 without return (EXEC @Results = spwho2)
Give a warning when tsql or stored procedure has execute a stored procedure without a variable for an error to bubble up to.
This is the proper way because ieven in a try catch the Exec sp_who2 won't give and error to stop the tsql from going on
3
votes
Jim McAleer
shared this idea