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 !