sp_indexoption

• Nilssond

  Hall of Fame

  Points: 3285

  More actions

  July 15, 2005 at 2:14 pm

  #88086

  If I execute sp_indexoption 'Mytable.Myindex', 'disallowpagelocks', TRUE

  how long will this remain true?  For the duration of the session, until the table is deleted?, until the index is re-built?

• July 18, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Joe Burdette

  Say Hey Kid

  Points: 707

  More actions

  July 18, 2005 at 8:26 am

  #575217

  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 level, stays for the life of the index!

  ---

  Regards,

  Joe Burdette
  hanesbrands.com