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 (3)

  1. Matt G says:

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

  2. Mujtaba says:

    Thanks dear, 4 yrs gone, still helpful. God bless you

  3. Viktor S says:

    Thank you for the excellent info !

Skip to main content