What tools are there to generate test data for SQL Server? As you can see from another question of mine, generating test data is my theme right now.

At this point, I'm still generating my test data by hand.  However, this process always generates small amounts of data (usually five-ten rows) since it is a manual process.

Are there any tools to automate this process?  Particularly, I'd like to be able to generate 1mil+ rows.
Red Gate SQL Data Generator?