Hi, could anyone tell me how to extract all the indexed keywords from the SQL server catalog of indexes please?
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#85a05b13aa901451 -- 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 "Alantis" wrote in message news:EC356C15-2717-4D56-A79D-3767C90DDD1E@microsoft.com... > Hi, could anyone tell me how to extract all the indexed keywords from the > SQL > server catalog of indexes please?
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... "Hilary Cotter" wrote: > 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#85a05b13aa901451 > > -- > 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 > "Alantis" wrote in message > news:EC356C15-2717-4D56-A79D-3767C90DDD1E@microsoft.com... > > Hi, could anyone tell me how to extract all the indexed keywords from the > > SQL > > server catalog of indexes please? > > >
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. -- 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 "Alantis" wrote in message news:41F0EC59-4B72-48CD-8999-4BD989B5B9E1@microsoft.com... > 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... > > "Hilary Cotter" wrote: > >> 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#85a05b13aa901451 >> >> -- >> 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 >> "Alantis" wrote in message >> news:EC356C15-2717-4D56-A79D-3767C90DDD1E@microsoft.com... >> > Hi, could anyone tell me how to extract all the indexed keywords from >> > the >> > SQL >> > server catalog of indexes please? >> >> >>
On Nov 26, 3:48 pm, "Hilary Cotter" wrote: > SQL 2008 may supply a DMV for this. > there are news on this? thanks
