How to Script a SQL Server Database with data or a Database Object with Data

Many a times we require a utility which can give us a script of a table along with data

i come accross a utility given by microsoft which is very usefull to do this.

You can download Database Publishing Wizard and install it.

In Database Publishing Wizard you can script table with design and its datas

In case you have Installation DVD of SQL 2008 you can find the same with the name

SqlPubWiz.msi