IT xtype objects

• shen-dest

  SSCrazy

  Points: 2498

  More actions

  October 31, 2011 at 8:05 am

  #259417

  hi all,

  there is a system created filegroup on our Production DB named "ftfg_TestCatalog" and in that filegroup 6 objects of xtype IT. how to drop that filegroup?

  here are object details and 564001586 parent_obj points to one of our live table.

  fulltext_index_docidmap_564001586 226724506 IT 4 0 0 0 0 564001586

  fulltext_index_docidstatus_564001586 242724563 IT 4 0 0 0 0 564001586

  fulltext_indexeddocid_564001586 258724620 IT 4 0 0 0 0 564001586

  fulltext_docidfilter_564001586 274724677 IT 4 0 0 0 0 564001586

  fulltext_avdl_564001586 290724734 IT 4 0 0 0 0 564001586

  ifts_comp_fragment_564001586_2 322724848 IT 4 0 0 0 0 0

  Regards,
  MShenel

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 24, 2011 at 3:11 am

  #1412609

  Looks to me like you have fulltext indexing setup on this database and it is being used for one of your tables.