query executed successfully but did not return number of rows SSMS 18.3.1

1.8k Views Asked by At

Executing simple select statement does not displays the number of rows returned.

It show "Query executed successfully" but do not show how many rows returned.

enter image description here

3

There are 3 best solutions below

4
On BEST ANSWER

Click the Messages Tab right next to the Results Tab.

Should say something like (100 rows affected)

2
On

The row Count in status bar is displaying by default, just be sure its flag is on.

you can check it form next navigation:-

Tools > Options > Text Editor > Editor Tab and Status Bar.

enter image description here

0
On

Old post, but Ahmed had most of the answer. For me I had to set the "Include row count" to false" first. Then the other normal status results began to show. Setting it back to true returned the row counts.