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
![](https://secure.gravatar.com/avatar/32d9908ca1de93bc50d8151d2addfbd9?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)