check out the Microsoft Knowledge Base, if you search on sp_indexoption, you'll get three references to this command... your detailed answer is there

short answer: the change is at the index...

nice article... I like the comment of "articles I write will focus on the 'command line' (namely Query Analyser) to provide DBA’s with a reference point to turn back to when...