How to get all lexicon (indexed keyword)?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alantis - 22 Nov 2007 04:16 GMT

Hi, could anyone tell me how to extract all the indexed keywords from the SQL
server catalog of indexes please?

Reply to this Message

Hilary Cotter - 26 Nov 2007 14:48 GMT

SQL 2008 may supply a DMV for this.

Right now the best you can do is to read your content and somehow build a
list. Here is a CLR function I used for this.

http://groups.google.com/group/microsoft.public.sqlserver.fulltext/browse_thread
/thread/e954a18bb47053cf/85a05b13aa901451?lnk=gst&q=goldshredder#85a05b13aa90145
1

Signature

http://www.zetainteractive.com - Shift Happens!

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi, could anyone tell me how to extract all the indexed keywords from the
> SQL
> server catalog of indexes please?

Reply to this Message

Alantis - 01 Dec 2007 09:31 GMT

Thankz man.
But Microsoft should provide an api to access the indexes to improve the
flexibility of utilizing the full text search functionality.
As usual, Microsoft didn't do that. So disappointing...

> SQL 2008 may supply a DMV for this.
>
[quoted text clipped - 6 lines]
> > SQL
> > server catalog of indexes please?

Reply to this Message

Hilary Cotter - 03 Dec 2007 14:52 GMT

they are working on a dmv which provides this for SQL 2008. They did ship a
tool called cidump which did this for the early betas of SQL 2005 but it was
considered a security risk as anyone with access to this tool and your
catalog files could read the contents of them, so it was yanked.

Signature

> Thankz man.
> But Microsoft should provide an api to access the indexes to improve the
[quoted text clipped - 12 lines]
>> > SQL
>> > server catalog of indexes please?

Reply to this Message

salucci - 09 Dec 2007 18:19 GMT

> SQL 2008 may supply a DMV for this.

there are news on this?
thanks

Reply to this Message