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.
Printable View
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.
Sql stores it in maintenance plan, will use it to build reindex statement.