venkat9.sql (1/22/2013)

---

I am a starter in sql server..
Can some one let me know why i dont get the 1 row(s) affected message as stated but simply
Command(s) completed successfully message..

venkat9.sql (1/22/2013)

---

Thanks for the reply. I didn't execute the code. I just used the display estimated execution plan.
I checked the messages tab and didnt get the 1 row affected message.

I am using 2008R2. I fiddled around ssms to see if I can display the rows affected message. but couldn't find anything. I did see few posts preiously stating that they didnt see the message either. I dont know if its a version difference or if its due to any settings in my ssms.

Thanks,
VJ

venkat9.sql (1/22/2013)

---

Thanks for the reply. I didn't execute the code. I just used the display estimated execution plan.
I checked the messages tab and didnt get the 1 row affected message.

I am using 2008R2. I fiddled around ssms to see if I can display the rows affected message. but couldn't find anything. I did see few posts preiously stating that they didnt see the message either. I dont know if its a version difference or if its due to any settings in my ssms.

Thanks,
VJ

Dave62 (1/22/2013)

---

Thanks for the feedback. Since submitting the question, I have done further testing on a default installation of 2008 R2 SP1 and have been able to duplicate the results. The other poster who had a similar problem mentioned 2008 R2 SP2 so if you are using SP2 also then I think your conclusion must be correct that it's either a version difference or settings issue.

This makes the behavior even more curious to me because I would think the Messages tab involves basic functionality. I would further expect more documentation if any significant changes occurred between versions. Oh well, I guess there's always something new to learn in SQL Server.

Enjoy!

Hugo Kornelis (1/22/2013)

---

... showing or suppressing the "xx rows affected" message is an option you can change. See my first message in this topic. In the message just above yours, I explain exactly how to change it.
Nothing curious.