Home Forums SQL Server 2008 SQL Server 2008 - General can I get the cuerry of an existing table...??? RE: can I get the cuerry of an existing table...???

  • November 5, 2012 at 12:49 am

    #1555899

    :exclamation:Indeed I don't need SSMSToolsPack
    ;-)this was a tremendous help thank you so much and works JUST FINE 🙂

    Sean Lange (10/31/2012)

    You don't need SSMSToolsPack to generate a script for the data. You can right click the database Taks -> Generate Scripts to bring up the Script wizard. On the Set Scripting Options section click the Advanced button. The last option in the first section of options (General) is "Types of data to script". By default this is set to Schema only. You can change that to Data only or Schema and data. If you choose the last one it will generate your create object script and inserts for all of the data.

    --EDIT--

    Of course SSMS Tools pack is a pretty darn handy extension though.