I came across this article on CodeProject. Alberto Venditti wrote an application that can be used to stress test your SQL Server 2000 database. I haven't gone into it in depth yet, but it looked interesting enough that I wanted to let y'all know that it's there.