Generate Script with data in MSSQL Server 2008
Step 1: Log in to your MSSQL Serevr
Step 2: Go to your database and Right Click
Step 3: Task--> Generate Script,It will open a window
Step 4: Click Next-->Ckeck the checkbox-->Next
Step 5: On current window, "Choose script option", go to table/view
operation after scroll down.
Step 6: Change "true" from "false" on script data option.
Step 7: Click on next-->next-->finish
The generated script also have script as well as data in insert command.