Following quick tutorial demonstrates how to create T-SQL script to copy complete database schema and all of its objects such as Stored Procedure, Functions, Triggers, Tables, Views, Constraints etc. You can review your schema, backup for reference or use it to compare with previous backup.
Step 1 : Start
Step 2 : Welcome Screen
Step 3 : Select One or Multiple Database
If Script all objects in the selected database checkbox is not selected it will give options to selected individual objects on respective screen. (e.g. Stored Procedure, Triggers and all other object will have their own screen where they can be selected)
Step 4 : Select database options
Step 5 : Select output option
Step 6 : Review Summary
Step 7 : Observe script generation process
Step 8 : Database object script generation completed in new query window
Reference : Pinal Dave (http://www.SQLAuthority.com), All images are protected by copyright owner SQLAuthority.com
Pinalkumar Dave is the author of over hundreds of SQL Server articles. He has
five years experience as a Director of Technology and Principal
Database Administrator in MS SQL Server 2005/2000 and ColdFusion MX. He
has a Masters of Science degree in Computer Networks, along with MCDBA,
MCAD(.NET) and ColdFusion Advanced MX Certifications.
