If I create an index e.g
Create nonclustered index(Path, Value, Id) with(sort_in_tempdb=on);
It doesn't fail but when looking at the index in SMMS, it says
False. Any ideas why?
EDIT: Can not find any schema to query for the value of this setting. Tried
sys.Indexes but with no luck.