I've got a database with a bunch of tables in it. There are a certain number of the tables (not all) that I want to create a script so I can create them in another database. These tables also has triggers associated with it. How can I create a script that will create the tables and the triggers and relationships ect in the new database. I am using SQL 2005. Any help would be greatly appreciated.