Post reply

index

  • October 15, 2007 at 11:28 pm

    #118687

    Hi Everybody,

    How can i make index offline mode in ms sql server 2005

    can u plz explaine me

    Ths& Regaurds

    siva

  • October 16, 2007 at 12:34 am

    #742236

    You can disable an index in 2005. use the alter index statement to disable a index.

    ALTER INDEX [index name] ON [tablename]

    DISABLE

    From BOL

    Disabling an index prevents user access to the index, and for clustered indexes, to the underlying table data. The index definition remains in metadata and index statistics are kept on nonclustered indexes. Disabling a nonclustered index or clustered index on a view physically deletes the index data. Disabling a clustered index on a table prevents access to the data; the data still remains in the table, but is unavailable for DML operations until the index is dropped or rebuilt. To rebuild and enable a disabled index, use the ALTER INDEX REBUILD statement or the CREATE INDEX WITH DROP_EXISTING statement

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

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