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

Question

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

neotokyo

SSCertifiable

Points: 7239
More actions
August 31, 2007 at 11:43 am

#174492

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

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

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

waor SSC Journeyman Points: 82 More actions · Answer 1

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'.

neotokyo SSCertifiable Points: 7239 More actions · Answer 2

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

_________________________

Bob Fazio SSChampion Points: 10794 More actions · Answer 3

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.

neotokyo SSCertifiable Points: 7239 More actions · Answer 4

nuts!

well... thanks for answering my question

_________________________

Pakorn Pankasem SSC Journeyman Points: 78 More actions · Answer 5

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'.

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