Grant Fritchey (8/24/2016)
It will do the business validations, absolutely. You just have to write the tests. There's not a tool out there that knows your business well enough to automatically generate tests for the business.
For what it's worth, one method of unit testing (or smoke testing) is to run and event profiler trace while QA tests some discrete set of features within the application, and then the saved trace can later be replayed to execute the stored procedure calls and statements in proper sequence using identical parameters. Still, the developer or QA replaying the trace must know what to look for in the error logs or data.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho