Post reply

DDL generation. please help

  • July 10, 2007 at 1:17 pm

    #117836

    I am trying to create a create/drop table script with table structure, all indexes,constraints , defaults everything. In 2000 we just ened to turn on eth options under DDl Generation option but how can we get the same work on 2005. Any help will be greatly appreciated. TIA

  • July 10, 2007 at 1:24 pm

    #718400

    In Object Explorer in SSMS, Right Click on the Database, and select Generate Scripts.  The wizard will walk you through generating what you are after.

  • July 12, 2007 at 1:04 am

    #718876

    You may also want to verify you are running sp2.  As I recall, I saw the same issue here and it was fixed with sp2.  Sorry, I was unable to find any documentation about it.

    Todd Carrier
    MCITP - Database Administrator (SQL 2008)
    MCSE: Data Platform (SQL 2012)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply