SSMS 2017 – Number of affected rows

SQL Server Management Studio is an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database. Be it a T-SQL developer or DBA, we spend most of our time working on SSMS IDE. 

SSMS 17.2 is the latest version of SQL Server Management Studio. It provides support for almost all features on SQL Server 2008 through SQL Server 2017.


I have been using SSMS 2017 since its release. While writing some SQL scripts this morning, something caught my attention – and hence this quick blog post.

Do you recognize the below messages indicating the number of affected rows when you execute a SQL query?

(1 row(s) affected)

(2 row(s) affected)

Since the earlier versions of SQL Server, I found it amusing when I used to execute a query which returns just 1 row and it would display a message – (1 row(s) affected)

Over the years, I have been used to looking at similar messages –

SSMS2016 rows affected

However if you have SSMS 17.2 version installed, execute the same set of queries in SSMS 2017. You will see that the term rows(s) is no more displayed.

SQL Engine correctly displays ‘row’ or ‘rows’ messages based on the number of rows returned.

SSMS2017 rows affected

As a SQL developer, I see this as the smallest enhancement which could have been made – but it really makes sense and was long pending!

You can check out SQL Server Management Studio 17.2 Release Notes here.



Categories: SQL Server, SQL Server 2017

1 reply


  1. Increasing your Coding Speed in SQL Server Management Studio 2017 – dotnetvibes

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: