SQL Data Generator
It will generator test data fro SQl server
Some of the features
Data generation in one click
Realistic data based on column and table name
Data can be customized if desired
Eliminates hours of tedious work
Full support for SQL Server 2008
Latest version 1.2
path to download
http://www.red-gate.com/products/SQL_Data_Generator/index.htm
Reference: http://www.red-gate.com/products/SQL_Data_Generator/index.htm