SQL Server Test

Please take a look at the below links.
http://www.sqlmag.com/Articles/ArticleID/47884/47884.html?Ad=1
http://www.codeplex.com/SQLLoadTest  

Thanks for the reply. As I mentioned in my post I already tried SQLIO, this is for doing a stress test on the server - it doesn't run simulated SQL transactions.  I am not sure about the second link http://www.codeplex.com/SQLLoadTest - it discusses Visual Studio. I want to be able to run this within Management Studio. I am not opposed to purchasing a third party application - do you have any experience with a specific program that has run simulated sql transactions?  Thanks.

I don't have any personal experince with these tools.But here is more options you have and great explantion too.
http://www.sqlservercentral.com/Forums/Topic442278-361-1.aspx
http://www.sql-server-performance.com/articles/per/stress_test_part3_p1.aspx  

Those links give the same info as your first response, either running SQLIO.exe or having to do coding in Visual Studio.   I hoping there is another alternative to doing this within Management Studio.

Well there is the Perf Stats Script and also I've heard of SQLDIAG and PSS read about it in this blog:
http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-2005-performance-statistics-script.aspx
Cheers
Rob

You cant do this from with Management Studio ..   you can do load testing from within team editon of visual studio db pro ...   but what performance are you wanting to measure ?  SQLIO will show you disk io performance for sql like transactions ...   ?  for cpu and memory .. you will have to test with your application to get true results ..  

I think the application I am looking for is called DBHammer.
If anyone has a link for where I can download this, please post. Thanks.

http://linux.dltube.net/download6018.html