Is “SET NOCOUNT OFF” necessary in a stored procedure?
set nocount on will disable the X rows affected. message SQL returns. This message is suppressed, in some cases, due to undesired effects with the client executing the stored proc. set nocount off will undo this suppression. However, set nocount on is a scope setting, and by default, will be turned off when leaving the … Read more