Prepare SQL script of complete database in SQL Server

Preparing script of database or prepare insert script for any table or all table is a common requirement in development.
SQL Server provide SQLPubWiz.exe for this purpose. it is generally available in C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.2 location.

it allows to prepare script for all objects of database which may include script for schema only, script for data only or both.

User can also enable drop for existing object of database.