Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Curt Blood
Starting Member
23 Posts |
 Posted - 2008-10-14 : 11:56:56
|
I have a database that uses a full-text catalog. Is there a query somewhere that will tell me which tables/columns are included in the catalog? I've looked in BOL and have found some interesting administrative things, but nothing to prevent my having to go to the Full-Text Catalog properties dialog and manually scrolling through the available tables (of which there are hundreds) to find which columns are included in the catalog.Thank you in advance for your help.--CurtWhoops, almost forgot!Expurts only please!!!!11!1!one!! |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-16 : 03:52:10
|
| You can use sp_help_fulltext_catalogs @fulltext_catalog_name = '<name>' to get all tables for a given cataloghttp://msdn.microsoft.com/en-us/library/ms175038.aspxYou can use sp_help_fulltext_columns to get all the column that are full text indexed for a given tablehttp://msdn.microsoft.com/en-us/library/ms187312.aspx |
 |
|
|
Curt Blood
Starting Member
23 Posts |
Posted - 2008-10-16 : 10:18:22
|
| Thank you very much, sp_help_fulltext_columns was exactly what I was looking for. |
|
|
|
|
|
|
Full-text catalog columns