View All Keywords in Full-Text Index

Question

View All Keywords in Full-Text Index

Jeff Moden

SSC Guru

Points: 1004439
More actions
March 5, 2011 at 8:42 pm

#233007

In BOL, they give this wonderful example of what a full-text index contains including the Keyword, ColID, DocID, and OCCurance. Is there anyway to actually see that information somewhere? Is there a way to return that information through a T-SQL statement?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004439 More actions · Answer 1

I guess I'll have to take the total lack of response to this thread as a reasonable solid "No, it can't be done". Thanks anyway, folks.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 2

Hey Jeff,

A bit of research is showing me that this is, at best, a mess.

For example, to deal with doc_ids, apparently you need to use sp_fulltext_keymappings http://msdn.microsoft.com/en-us/library/cc645845.aspx... but that doesn't help you on occurance, but it'll show you how to get at all the docids.

from there, sp_help_fulltext_catalog_components will get you at a list of all the components for the catalogs. This page has a list of all the sp's available for accessing Fulltext catalogs, and I can't locate anything that will get you at the occurence counts.

Sorry man.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA