Results 1 to 2 of 2

Thread: SORT_IN_TEMPDB index option

  1. 06-22-2009, 12:30 PM #1
    robpatt
    robpatt is offline Registered User
    Join Date
    Jun 2009
    Posts
    3

    SORT_IN_TEMPDB index option

    Can anyone tell me where SQL Server stores this option?

    I have looked in sysindexes, sys.indexes and also used indexproperty() and indexkey_property() and have found every other index option EXCEPT sort_in_tempdb.
    Reply With Quote Reply With Quote
  2. 06-22-2009, 01:05 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Sql stores it in maintenance plan, will use it to build reindex statement.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules