View affected rows of UPDATE query

The best way to do this by defining Audit and then database Audit specification.

Please check this article;

http://ift.tt/1lbN8V8

---

Please visit my Blog for some easy and often used t-sql scripts

My BizCard