bitbucket-25253 (1/18/2013)

---

...

Been there done that ... the message tab is NOT, let me repeat, the message tab in NOT part of the estimated execution plan

I think the message tab is very much a part of the estimated execution plan. When you run the exact same commands 3 different ways, the message tab displays differently for each way. This would indicate that what is read in the message tab can vary depending on how the commands are run.

Take these 3 commands run against the AdventureWorks database for example.

Select COUNT(*) From Person.Contact;

Select COUNT(*) From HumanResources.Employee;

Select COUNT(*) From Production.Product;

1) If you just execute the code, you will see 3 messages that say 1 row(s) affected

2) If you only click the Display Estimated Execution Plan button, you will see only 1 message that says 1 row(s) affected

3) If you click the Include Actual Execution Plane button and Execute, you will see 6 messages that say 1 row(s) affected

Enjoy!