Last month, Microsoft released the MSSQL Database Publishing Wizard. This tool can easily generate a script with the database schema and corresponding INSERT statements. It also has integration to VS.NET 2005, which is a very nice bonus.
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.