Post reply

exporting ''create table'' scripts with ONLINE = OFF??

  • August 31, 2007 at 11:43 am

    #174492

    wrong question.... create table scripts with Indexes Disabled?

    _________________________

  • September 5, 2007 at 3:41 am

    #731432

    If you mean you cannot generate table scripts with index, go to that specified database name and right click, choose tasks, generate scripts, next, choose dbname, set script indexes under table/view options to 'true'.

  • September 5, 2007 at 8:23 am

    #731521

    yes of course... but... can you create them (somehow) in a disabled state?

    _________________________

  • September 6, 2007 at 6:33 am

    #731789

    Hmm... I am assuming you want to put the DDL in a database, but not initially create the index to be "rebuilt" at a later date. 

    There is no way to create an index in a disabled state as far as I can tell...  Period.

    However you can create statistics that can be used as hypothetical indexes.

  • September 6, 2007 at 8:00 am

    #731833

    nuts!

    well... thanks for answering my question

    _________________________

  • November 8, 2010 at 10:11 am

    #1247749

    wanlapa

    If you mean you cannot generate table scripts with index, go to that specified database name and right click, choose tasks, generate scripts, next, choose dbname, set script indexes under table/view options to 'true'.

    ????????????????? ????????????? ???

Viewing 6 posts - 1 through 5 (of 5 total)

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