A. That would be the IMAGE (or sometimes referred to as a BLOB) datatype. Specificly, in the SQL code example above it would be column: ImageCol image. For Full-Text Search purposes,...

Once you've parsed the single MS Word document into mutiple chapter-specifc MS Word documents (or text files), you can use Textcopy.exe to import either the MS Word or text file...

You're welcome

As you referenced 24x7 support, I had suspected that you already had...

To answer your question directly, yes there is... Specifically, to achieve "High Availability" (HA) or 24x7 support for Full-Text Search (FTS), I'd recommend that you consider implementing SQL Server 2000...

To further clarify... The memory requirements of MSSearch are controlled by the resource_usage parameter of the stored proc sp_fulltext_service, but not the OS memory usage. Specificly, the MSSearch resource usage level can be...

You can also use FORMSOF(INFLECTIONAL) for test and testing as testing is a valid word variation to test, however, this will not work for testing2 and you will need to...

Xavier,

Can I assume that the language in your FT-enabled column is Spanish? If so, then you need to use system stored procedure "sp_fulltext_column". The below workaround is from a bug I filed...

In regards to your first question, the answer is Yes it is possible to install and run full-text search (FTS). SQL FTS is not installed by default with the SQL 2000 Developers Edition...

Unfortunately, with SQL Server 2000 there is no supported way to get either the unique non-noise word lists or statistics of these word lists (word frequency, etc.) directly from the...

Could you provide some additonal information? Specificly, what version of SQL Server (2000 or 7.0) and on what OS Platform it is installed via -- SELECT @@version -- and sp_help...

Yep, adding a clustered index on MYID and [non-clustered index on] MYFIELD2 will always help query performance issues on large tables, even if FTS is not used!

Depending upon how large your FT-enable table is, you may want to consider using the new Top_N_Rank parameter with your CONTAINSTABLE query, for example:

select FT_TBL.* from MYTABLE as FT_TBL,

CONTAINSTABLE (MYTABLE, MYFIELD,...