• Don

    The easiest way is indeed to create a script.  Right-click on the database in Enterprise Manager and choose Generate SQL Script.  You can then make lots of choices about what objects you script and how.

    John