Skip to main content
replaced http://stackoverflow.com/ with https://stackoverflow.com/
Source Link
URL Rewriter Bot
URL Rewriter Bot

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)

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)

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)

Source Link
Adeem
  • 1.4k
  • 1
  • 18
  • 31

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)