How to script out your database objects (Database Publishing Wizard)
I work with MySQL, and MySQL has a mysqldump client that scripts out database schemas + records in the tables.
There is no “native” tool in SQL Server 2000/2005 that does this (as far as I know). Luckily there’s a SQL Server add-in that allows scripting of both schema + records.
You can download the Database Publishing Wizard from CodePlex: