<p>What tools are people using for testing SQL Server databases?</p>

<p>By this I mean all parts of the database:</p>

<ul>
<li>configuration</li>
<li>tables</li>
<li>column type</li>
<li>stored procedures</li>
<li>constraints</li>
</ul>

<p>Most likely, there is not one tool to do it all.</p>

I personally use NHibernate with SqlCe, this provides a "throw-away" database that doesn't need any specialized tear down after the tests are run.
It also provides a good way to test your nhibernate mappings if applicable.
Here is a link to an article I wrote awhile ago on how to accomplish this:
http://www.codeproject.com/KB/database/TDD_and_SqlCE.aspx?display=Print