full-text queries with express edition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nalaka - 13 Feb 2006 19:19 GMT

Hi,
I understand that full-text indexing is not available in the express
edition.

My situation is that we have to write an application to take advantage of
full-text-indexing when available.

Quesitions are.
1. Does "freetext" and "contains" queries works on express edition?
(by doing a full table scan or something like that)

2. If it does not, how do I write the c# that recognize the capability,
so that c# code can send/execute different queries based on
"full-text-capability" of sql-server.

any direction is deeply appreciated.

Thanks
Nalaka

Reply to this Message

Hilary Cotter - 14 Feb 2006 03:44 GMT

1) It currently does not work on SQL FTS.
2) I believe the February issue of SQL Server pro has an article on how to
get this working using pure tsql.

Signature

Hilary Cotter
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,
> I understand that full-text indexing is not available in the express
[quoted text clipped - 15 lines]
> Thanks
> Nalaka

Reply to this Message

Daniel Crichton - 14 Feb 2006 09:15 GMT

Nalaka wrote on Mon, 13 Feb 2006 11:19:10 -0800:

> Hi,
> I understand that full-text indexing is not available in the express
[quoted text clipped - 12 lines]
>
> any direction is deeply appreciated.

In my code I first do the following:

select FULLTEXTCATALOGPROPERTY('STKcatalog', 'ItemCount'),
FULLTEXTCATALOGPROPERTY('STKcatalog', 'PopulateStatus')

If NULLs returned, FTS is not available for the named catalog (in my case
STKcatalog). I also use these values to double check whether the index is
being rebuilt, and to make sure that the ItemCount value is close to my
table row count. This way if there is not FTS catalog, or it's being
populated, I can switch my query to use LIKE rather than CONTAINS.

Dan

Reply to this Message