CODEWITHSUNDEEP
sql-server-2005ssms
Adeem
Adeem

Reputation: 1346

SQL Server Management Studio terminates silently

I am facing issue that SQL Server Management Studio terminates silently apparently when text in message panel is too big e.g. a few million rows.

Is there a solution for this?

And also can we clear this message panel while stored procedure is executing? I am using print statement to see the status of execution. FYI I have data of 3+ million rows to process.

Upvotes: 3

Views: 144

Answers (1)

Adeem
Adeem

Reputation: 1346

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)

Upvotes: 2

Related Questions