A utility to generate unit tests for Visual Studio Team Suite has been posted to Codeplex. This tool takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed to be used in a Visual Studio Load Test. The code generated is easily modifiable so that data variation can be introduced for the purpose of doing performance testing.
To get more information and to download the utility, follow this link: http://www.codeplex.com/SQLLoadTest
To learn more about Visual Studio Team Suite's testing capabilities, click here: http://msdn.microsoft.com/en-us/vsts2008/test/default.aspx