I'm not sure how I missed this one -- it was posted in April, 2004 -- but I will pass it along here since I'm sure others will find it useful, too.
Alberto Venditti shares a simple VB.NET stress utility for SQL Server 2000. It's kind of similar to the Database Hammer that came with the SQL 2000 resource kit, but looks a lot easier to set up and use.
Great job, Alberto!