I would recommend not setting that in the stored procedure because this reduces the possibilities of the return. When the stored proc is called from programming code, the call can be set to not return a record count. If it's set in the stored proc, the programmer has no way to get the count if it would be desired.