Right-click database > tasks > generate sql scripts, then select the table and on the scripting options page, select advanced, choose "schema and data" in types of data to script.
I think this option is available only in SQL Server 2008. I dont think SQL Server 2005 or earlier versions have this feature.
No comments:
Post a Comment