Script table data in SQL Server 2008Posted: December 4, 2008
When you script your database objects, the default setting for script data for a table is false. You can change the setting to true to script your table data.
Right click on your database>>Tasks>>Generates Scripts… (Load the Wizard)>> click NEXT>>Choose database and click NEXT>>within Choose Script Options window, scroll down to Table/View options section and change Script data option to True.>>Next to choose table to script>> click NEXT and NEXT to clcik the Finish
button. You will have your table along with the data in a script.