• Fabian Wetzel
  • 2010-12-08
  • 1 min. read

Create insert script including data with SQL Server Management Studio [for real]

After a co-worker of me had not been able to find the right option (but was able to help hisself anyway) I decided to share the trick:

Right click your database, select “Tasks”, then “Generate Scripts”:

image

Follow the wizzard, but change the option to script data to true:

image

You should be able to figure out everything else on your own.