SQL to see what documents are supported?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

newscorrespondent@charter.net - 26 Oct 2006 14:36 GMT

I once had some SQL to see what document types are supported by Full Text
Search that worked at least for SQL2005 and lost it.

Can somebody post that again please?

Would be nice to have for SQL2000 if it is possible also.

Thanks

Reply to this Message

Hilary Cotter - 26 Oct 2006 15:23 GMT

In SQL 2000 you need to use a tool like filtreg. In SQL 2005 issue a call to

select * from sys.fulltext_document_types

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

> I once had some SQL to see what document types are supported by Full Text
> Search that worked at least for SQL2005 and lost it.
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

newscorrespondent@charter.net - 26 Oct 2006 17:08 GMT

Thanks for that quick reply.

Reply to this Message