How can I generate INSERT statements from Management Studio

MohammedLayes

Hello All,

How are you guys doing Hope all is well.

This is my problem...I accidentally deleted a bunch of my SQL scripts and would like to generate the INSERT statements from Management Studio. I am currently using SQLExpress. Is there a way I can accomprish my task Kindly advise.

Thanks a bunch!

Mohammed

Jens K. Suessmeyer

No, you can¡¯t SSMS does not support that yet. You can create the statements using the script from here:

http://vyaskn.tripod.com/code.htm#inserts

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---

Andrea Montanari

hi Mohammed,

in addition to Jens, you can have a look at http://www.karaszi.com/sqlserver/info_generate_script.asp, where "several" option are listed.. for your convenience, you can perhaps try a free prj of mine, amInsert, available for free at the link following my sign..

regards

MohammedLayes

Hello Jens!

Good to hear from you and thank you for responding to my post. I really appreciate your assistance. I used to live in Germany myself...in Bonn....and I had an amazing time...and I would love to go back there!!!

Thanks again,

Mohammed

MohammedLayes

Hello Jens,

Sorry to bug you again. Would I be able to generate the INSERT statements if I was using full-blown SQL Server 2005 ...or does this have nothing to do with the fact that I am using SQL Server Express

Thanks,

Mohammed

Andrea Montanari

hi Mohammed,

even SQL Server Management Studio "full version" does not provide that feature..

regards