Indexes

• Abhijeet Chavan

  SSCommitted

  Points: 1511

  More actions

  August 23, 2010 at 12:33 am

  #222979

  I want a list of indexes having SORT_IN_TEMPDB option OFF. I tried to search in Sys tables but i Didn't find it.

  Please help

  Thanks

• ColdCoffee

  SSC-Dedicated

  Points: 39972

  More actions

  August 23, 2010 at 12:50 am

  #1210259

  This thread will help you out:

  http://www.sqlservercentral.com/Forums/Topic739604-360-1.aspx

  ~Edit : Fixed the IFCodes