Home Forums Article Discussions Article Discussions by Author Discuss content posted by michael vessey move all indexes to a secondary file group RE: move all indexes to a secondary file group

  • August 31, 2008 at 9:47 am

    #865497

    keppro (8/30/2008)

    Thanks a lot to the author!

    One problem with the script: it doesn't recognize indexes with included fields. Does anybody know what system table(s) contain this information? Better yet, is there any kind of API for Management Studio's scripting?

    It is in sys.index_columns, with the included columns marked by a 1 in the is_included column.

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/