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.
Menu-option Query / Query Options ... / Advanced / untick
SET NOCOUNT (for current query window only)
Or: menu-option Tools / Options / Query Execution / SQL Server / Advanced / untick
SET NOCOUNT (default setting for all new query windows; will not affect windows already open)
Or: Execute "SET NOCOUNT OFF;" (for current query window only; can be used to change setting for parts of a longer batch, but will only work when actually executing the code, not when requesting estimated execution plan)
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis