Richard M. (1/20/2010)
Jeff Moden (1/19/2010)
And just so you know, rebuilding indexes using the "Online" option is only an option in the Enterprise and Developer's (Enterprise with very limited licensing) Editions...... and in order to be bale to do the online indexing, the tables cannot contain: XML index, Spatial index, Large object data type columns (image, text, ntext, varchar(max), nvarchar(max), varbinary(max), and xml) in which case you need to do an offline reindexing (which does not mean taking the database off-line...)
..and what we can do instead ?
we have navision 4.0 sp3 with many tables who have clustered indexes
and columns with data typ image etc.
we must accomplish an 24x7 manufacturing plant, there is no offline possible.:w00t:
thanks for an answer.