http://www.sqlscripter.com/
Jeremy Van Dijk has released his 7 th update to his SQL Scripter utility and it is now available for download. The SQL Scripter works with SQL versions 7.0 and greater. It will allow you to generate SQL scripts in T-SQL format for your database tables that can in turn be executed within SQL.
You can also use the SQL Scripter to make copies of all of the tables within a specified database for disaster recovery or to see what tables and such are in each table for documentation purposes.
Check it out!