Hi,

1. When creating a new datbase from an original one (without the data
being carried over), how do you copy the procedures, triggers and
views as well?

2. Do tables and procedures have to be stored in the same database
file, or can you one database for the procedures (central database)
and other databases for the tables on the same server?

Thanks