CODEWITHSUNDEEP
sql-serverssmsssms-18
Serdia
Serdia

Reputation: 4428

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

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

Upvotes: 0

Views: 2234

Answers (3)

Leland Daniel
Leland Daniel

Reputation: 21

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.

Upvotes: 1

ahmed abdelqader
ahmed abdelqader

Reputation: 3568

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

Upvotes: 3

TrevorBrooks
TrevorBrooks

Reputation: 3840

Click the Messages Tab right next to the Results Tab.

Should say something like (100 rows affected)

Upvotes: 1

Related Questions