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