• Hi

    Sorry if this sounds obvious, you can script the entire db using management studio, right click on the db go to all tasks and script db.

    You can also expand the security folder and then the schema folder, and script each db schema individually.

    Hope this helps

    Gethyn Elliswww.gethynellis.com