How to see all full text index

• ubaert

  SSC Veteran

  Points: 286

  More actions

  November 13, 2003 at 3:37 am

  #176943

  hi

  how can i get all full text indexes? is there a command to view all unused indexes?

  urs

• November 17, 2003 at 12:00 pm

  This was removed by the editor as SPAM

• skrilla99

  SSCertifiable

  Points: 5795

  More actions

  November 17, 2003 at 4:41 pm

  #482335

  ubaert,

  you can list the full text indexed columns by using:

  sp_help_fulltext_columns

  Also, you can list the catalogs by using:

  sp_help_fulltext_catalogs

  There are other sprocs in the master database that may help. Look these two up in BOL for more info.

  -Dan B