Client tool was crashing when it exceeded memory usage while showing row counts. I simply used
"SET NOCOUNT ON"
"SET NOCOUNT OFF"
I found solution at following post:
How to stop SQLServer writing extraneous stuff eg (1 rows affected)How to stop SQLServer writing extraneous stuff eg (1 rows affected)