Here's my version of SQL Server 2000 running on Windows Server 2003. Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) I have a FTI catalog defined on a tab...more >>

we have created a full text catalogue on an Addresses table with exactly same configuration on 3 databases. Two of them are on SQL 2005 and one on SQL 2000. My Addresses table has 13 million rows and the full text was on the Full Address column. db is around 250GB FT Index on SQL 2005 d...more >>

Machine A (2003 Server, sp1) is running SQL Express with FTI. Querying the fulltext catalog returns results as expected and the catalog is kept up-to-date when data is added/modified in the indexed tables. Machines B and C (Xp Pro, sp2) are running a restored copy of A's database. However...more >>

I have created a FT Index on a varchar(200) col of my 'movies' table. The table has about 2000 rows, so there is lots to index. But even after forcing a catalog rebuild and full population, the catalog remains empty. (item count 0, unique key count 1, etc..) Any ideas ? ...more >>

Hi, I would like to know the major difference between Incremenatal Population and Track Changing Population. The only difference that I've found is the Incremental needs to have a timestamp column in the table. How do I decide if I should use Incremental or Track Changing? are there any ...more >>

I have a problem. I use Constainstable to make a fulltextsearch over 4 tables. Now I want to order the result set. The problem is that if I insert the column all_ranks in the Select part I have some double results. That is because some keywords are 2 times or 3 times related to an expert. So ...more >>

I am running SQL 2005 SP1 and I have a database I'm using for GFI Mail Archiver. When I run queries against the database for a specific word i.e "testing", only 2 results show up when there should be more results. I know the data is there because I can see it, it's just that when I do a ...more >>

Hi, as I read in the SQL 2000 Server FAQ that free text search ranks aren't suitable for calculating percentage values, what other ways are there to get sensible results for presenting to a user? Or are there none at all? Thanks in advance. Best regards, Andreas ...more >>

Does anyone know what the services are involved during the SQL full text index catalog population? Some of my application event log errors are "Error: 80070426 - The service has not been started.". I know that my SQL server is running and MSsearch is running. I don't know any other services n...more >>

Is there any function that we can to check the length of the full text index population and the status(whether it is finished successfully or failed)? Now I have to check it from application event log to determine how long it takes. We can see SQL job's "Run Duration" from job history. Is the...more >>

Can anyone advise the latest version(s) of the ifilter we should be using for a x64 Windows 2003 Server, I'm troublshooting an issue and want to ensure I have the latest x32 & x64 version's of this file on the relevant server's etc.. Thanks...more >>

We recently upgraded our sql server to 2005 and now all the Full-Text indexes return zero results. I have created a new fulltext catalog and a done a full population. After the population the catalog props read Unique Key Count : 1, Catalog Size : 0 MB. The event viewer and sql logs show no e...more >>

We are live (production system) running - Windows 2003 Data Centre Edition R2 x64 - SQL Server 2005 Enterprise Edition x64 SP 1 The system has been operating fine for 7 days and all of a sudden we have started getting this message every time we backup our database. The backup fails!!! We...more >>

Hi, I need to search a Items catalog that has a field that is key word seperated by commas. Would a fulltext search be more productive than a like searcn. If the use keys in Bic Black Pens then that is all it should bring up but if they key in pens it should only get pens. With the like I h...more >>

Hello, I have some questions about Full Text Search and how to handle a scenario that I have. The database that I am going to hit up against has 80 tables and over 250 fields that will be searched for FTS. This database has 600 + tables in it so 80 is needed to make the search meaningfull for...more >>

I have a table with Full Text index on it, the table has at the most 300 records. The database is on the live server and gets hit a lot. Every morning when i come to work the table is inaccessible, meaning any query that i issue to this table runs indefinitely, Select, update, Insert all j...more >>

Hi, I am using SQL server full text indexing for indexing and searching webpages. If I do a search after about 20 minutes of not searching, I get a long wait (>40 secs). Searches after that take <1 sec. Is this a memory issue, i.e. the index needs to be loaded into memory, which is causing t...more >>

I have a full text index scheduled at every night in SQL server 2000. Normally the status on the full-text catalog will either "Idle" or "Incremental population in progress". But today I got "shut down". This happened to one of our other server yesterday too. Since this happens more often now, I...more >>

So I've got an FTS enabled table where I store several different types of documents (xls, doc, pdf) in a varbinary(max) field. All my searches pull back the proper results, but how do I show an extract of the actual text near the search terms? I would like to display the first 50 characters ...more >>

I create a catalog. The exact same database tables work in another environment for the full population. But this server when I do a full population...it just hangs and says population in progress. However the item count, unique key count and catalog size does not grow. There's nothing in th...more >>

I am getting the following error, when i am trying to pass the NULL value to the parameter of Stored procedure. That parameter has been used in Contains clause in T-SQL. Server: Msg 7603, Level 15, State 1, Procedure spCMXLSearchReports, Line 256 Syntax error in search condition, or empty o...more >>

Hey there :) Sorry if I'm asking dumb questions, but I'm not really a MSSQL man myself, I've always used MySQL, but this particular project that I'm involved with right now uses an MSSQL Server. So, I have one question. Is it possible to have fulltext indexing on a table with a condition? As...more >>