none
(Sumber: milis SQL Server) Rebuild index RRS feed

  • Pertanyaan

  • dear all,
    Saya melakukan rebuild index di sql server 2005 enterprise. TErnyata menemui eror seperti ini; "
    Online index operations can only be performed in Enterprise edition of SQL Server"
    Mohon solusi dalam mengatasi hal ini.
    Thanx


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Kamis, 26 Juli 2012 08.22
    Moderator

Jawaban

  • Saya rasa dari message errornya sudah jelas, karena sql-nya bukan versi enterprise, sehingga tidak mendukung fitur rebuild index with oline, coba rubah option rebuild indexnya menjadi off
    Alter index all on dbo.mxyz rebuild with (online=off)

    Dijawab oleh: Deni Kusdeni


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Kamis, 26 Juli 2012 08.22
    Moderator