I am calling stored procedure using SQLCMD which will insert data into multiple tables. And output of that procedure is captured in log file using
-o. But, i can't see Row(s) affected any where in the log file. And same when I am executing procedure I am getting Row(s) affected.
Is there any other way to print Row(s) affected in log file along with print statement. I have tried using
SET NOCOUNT OFF as well but no use.