SQL Server 2008 R2 - generating INSERT statements for a table

Learned something new today. Maybe it’s well-known, but new to me, you can just run “C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.4\SqlPubWiz.exe”. This nifty little tool can generate INSERT script very easily. Pictures tell the story :)

Comments

• Anonymous
  May 19, 2011
  Finally!!!!  Thanks for this post, nothing else I found works with Microsoft SQL Server Management Studio Express 2008 R2

• Anonymous
  April 05, 2014
  The comment has been removed

• Anonymous
  September 25, 2014
  Thank you for the excellent info !