Noel,

The problem you've encountered is well known as the BUILTIN\Administrators account MUST exist for the external "Microsoft Search" (mssearch.exe) server to access SQL Server and this is by design. A...

Yes, I do. However, before you can delete the FT Catalog, I need to know more about your enviroment. Could you run the following SQL code and post the results...

Hi,

SQL Server 2000 (and possibly SQL Server 2005) limit the Full Text Indexing of large files to (see BOL title ? , cannot find this reference at this time, will post this...

Jim,

The most important think to understand but interputing "funky" SQL FTS results to know what OS platform your SQL Server is installed on, primarly because the word breaking dll that...

You're welcome, Harcharan,

The best location for your FT Catalog folder is on a disk drive (RAID0 or RAID10 perferred and not RAID5) on a disk controller that is separate from your database files...

Steve,

Well, I guess I am a "great full text expoert" (whatever that is ) as I maintain a blog on this subject as...

Hi Rob,

I'm a bit late in this tread, and I thank Frank for pointing you to my blog, as I was able to...

Ok, I think I know what you're trying to do and if my assumptions are correct, it is possible to do this without using cursors, or duplicating 40% - 50% of...

I begin to understand what you're looking to accomplish. Effectively, you want to "break the tie" between Rank values returned from a CONTAINSTABLE for your table Families based upon supplied...

First of all, you cannot FT-enable a #temp table, but your can FT-enable the Tempdb database and then FT-Index and run a Full Population on tempdb..temp1. This assumes that tempdb..temp1 has...

Gary,

Yes, you are correct. Your user must have the server administrator permission level to admister Full-text Search, even though he has the DBO permission level. Specificly, see SQL Server 2000...

You are correct that SQL FTS queries using CONTAINS or FREETEXT are not supported with SQL MSDE 2000, so a pure T-SQL solution is your only option. However, with a table that...

Joseph,

You might want to consider using SQL Server 2000 Full-text Search (FTS) and the CONTAINS or FREETEXT predicates. Specificly, search the BOL for "full text" (using the double quotes) and...

Good question...

I believe that FULLTEXTCATALOGPROPERTY gets its metadata of the FT Catalog from Registry keys under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\. I'll post back exactly where, but it is registry driven.

You might also be...

You're welcome, Conprog,

No, I'm only meant to say that you would get different results from using T-SQL LIKE (pattern search algorithm) vs. CONTAINS or FREETEXT as these use language-specific linguistic word-based...