It only complicates the test, wastes valuable machine cycles, reduces reuse across multiple versions, and often leads to long term maintenance costs. For an example of this see my previous post.

Google rolled back the blogger service to a pre-maintenance state and placed the service into read-only mode while the company worked through the problem, making it impossible to post to blogger.

Is the text of a Transact-SQL query used to do any post-processing cleanup or state maintenance, like updating chronicle tables or deleting any temporary objects.