I can execute the following to identify a word count: select fulltextcatalogproperty('items_idx', 'UniqueKeyCount') as count; If I execute this locally I get a count as intended. If I include this query in interface code, though, it comes back with a null object instead of the expected value...more >>

I get the following error: Msg 7619, Level 16, State 1, Line 1 Execution of a full-text operation failed. A clause of the query contained only ignored words. When I do the following: select * FROM SomeTable where CONTAINS(FullTextSearchEnabledField, 'P.A.s') Can someone tell me why I g...more >>

I am trying to get FTS to work on an SQL Express (Advanced) database. I have a table with a unique index(int), a column type field (nvarchar(15)) which I set to "Image" and a word document field (Image). I set up the catalog and the full-text index and verified that both are running OK. When ...more >>

http://www.simple-talk.com/2006/04/21/understanding-sql-server-full-text-search-part-i/ -- 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 RelevantN...more >>

Is there any way to 'read' a FT Index in SQLServer 2005. We are having problems getting our populations to index all records on one of our SQLServer machines, and we would like to know which ones aren't getting indexed. ...more >>

Hi, I have a table which contains the following data in one row: ID Category Keywords 16558 Make-Up Assistants makeup make up assistants 35976 Make-Up Artists makeup make up artists 35977 Make-Up Supplies makeup make up supplies However it seems impossible for users ...more >>

Hello, We recently migrated to the Windows 2003 and SQL2005. Besides many things we have not pretty much tackled, there is one issue remaining that I don't understand: Consider this query:- SELECT TOP 250 * FROM [news] [news] INNER JOIN CONTAINSTABLE([news_recent], [content],...more >>

Howdy, We have a SQL 2005 std server running on Windows 2003. We are having an issue where it looks like the full text service is locking up. In the activity monitor we will start to see processes waiting on MSSEARCH. The processes will continue to wait until I stop the SQL Server Full...more >>

I have a windows app written in vb.net with an SQL Express backend, which is used to track candidates and their resumes. Right now each candidate record has a link to a word document resume. I would like to be able to search resume's for key words in order to quickly locate all candidates who ...more >>

Hi Howto do a sqlserver 2005 backup WITHOUT the FTS catalog using BACKUP DATABASE TO DISK T-SQL Command ? Regards, Frédérick ...more >>

Hi, Given the following table Table : Computer ID Name Notes 1 03-computer01 This webserver (ws) uses a SQL server 2 cls0001NTS5 Is connected to ws03sql001 3 ws03sql001 4 ws03sql002 5 ws03sql003 3 sql-ws03 and knowing that the Name and N...more >>

Hi, Is it possible to explorer inside of full text indexes and see the words? Thanks in advance, Leila ...more >>

This is my first attempt to write a sp using a full-text search. It is a straight forward search of a classified ad table where the search words can be one or more words. It can be a word like 'Harley' or a phrase like 'for sale'. The problem I am having is that I get an error if I pass in ...more >>

Hi: I'm trying to get a handle on the best way to approach this issue. I have a product database of candy with perhaps 5000 products, and I'm indexing the product name and description fields (both varchars). People will search for "easter candy" for example. Splitting the string and using...more >>

Sometimes the scheduled full backups on MY_DATABASE are not performed, throwing the following error related with the fulltext catalog (CATALOG_XXX) that it's used by some tables: "The backup of the file or filegroup "sysft_CatalogXXX" is not permitted because it is not online. BACKUP can be pe...more >>

Hi, I am running SQL Server Standard on my development machine, Windows XP Pro. I have restored my clients database into my SQL Server 2005 instance (named SQLSERVER_2005) . I use a named instance because I still have SQL Server 2000 and SQL Server 2005 Express instances running on the same ...more >>

Hi there, I have a database with ca. 150000 city names in the field city (nvarchar). When I now search like this: ....where CONTAINS(city,' "wash*" ') I get a list of all results where the word "wash*" is included - thats fine but not what I am looking for. Because the result looks like ...more >>

Hi all, we have Windows 2003 SBS with SP1 and MS SQL 2000 with SP3. What is the recommended process to install full-text searching component to sharepoint intances of SQL 2000? First install this component from CD then reinstall service pack 3? Is mssqlserver service stopped during this in...more >>

Hi All: I had a SQL 2000 server that had full-text installed, and I did a "simple" upgrade to 2005 (ran setup without playing with the parameters). I'm trying to configure full-text now with 2005 installed, but I can't find any of the "noise" libraries where the docs say they should be: ...more >>

I'm new to SQL 2005, and I'm trying to create my first FT catalog using the wizard. After selecting the tables and columns I wanted in the index, I received an errorbox, the copied text of which is: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot l...more >>

Hi Is there any whitepaper written on performance in fulltext searches improvements one can expect going from storing PDF's in SQL Serfver vs. Index Server? We are piloting a product that has slow search retrieval, particular with many concurrent users Thus it might be speeded up by u...more >>

I have over 1 million emails with attachments that I would like to store in sql2005 using full-text search on the emails and attachments. Anybody see any problem wih this (could be over 200 gig depending on the attachments that are included)?...more >>

I am reposting this under this subject area as it is more appropriate here. ---------------------------------------------- My understanding of the fulltext search using the thesaurus function is that it will not work until the TSxxx.XML file is populated (in my case the tsENU.xml file.) Is th...more >>

does all ifilters work with fts? There's a new ifilter for msg's but designed for windows desktop search. Is the architecture of fts such that it will work with any ifilter? link to the download: http://www.microsoft.com/downloads/details.aspx?FamilyID=134ecbb0-c162-4d07-bef3-0b602c4a79d...more >>

I have Full-Text enabled on a small test database trying to resolve the issue above. I have a single table with two columns, col1 being the PK and col2 holding some text. I have build the catalog and populated it, the query I am executing is: select * from ft_table where contains(col2,'"...more >>

hi, i've looked for clues but haven't found anything. does SQL Server 2000 provide any assistance in stripping noise words from a query? when we solved this with ASP 5+ years ago we built a regular expression from our noise word tuning file and have used it since to strip noise words from q...more >>

I'm trying to set up Full-text indexing. I installed the module, the service shows up in control panel\services, but the option in EM is still grayed out. Any suggestions? FYI: SQL2000 on XP pro, rebooted machine... thanks. -Rob T. ...more >>

Hello Does anyone know if there is a limit to how many items(item count) a single catalog can hold? I have a table with over 30 million records and it only gets up to a little over 14 million in the item count and never finishes the population. It just says population in progress weeks. ...more >>

I have just built up a table with full text index under SQL server 2005. My problem is, for some query the sql server will return different number of result at different time, even though the same search term is used. for example, in the following query: select * from foo where contains ...more >>

Hi, I have a query about how the use of weighted terms impacts the rankin of articles. I am using MSSQL 2000. My query is about how is searching with just "containstable" differen from searching with "containstable isabout", where I provide sam weight to all the terms. E.g., if I am searchi...more >>

We get the following in error in the application log on out sql 2000 server. SQLFTHNDLER Event: 2001 One or more documents stored in image columns with extension '.rtf' did not get full-text indexed because loading the filter failed with error '0x8007057f'. Note: These documents will not be...more >>

Hi everyone, Hope that you can help me with this one. Is it possible to use return the result of a full text index that have a preference for a particulat word. What I mean by this is that we have a full text index of 1.34M records. We want to return the rows that contain the the word Dub...more >>

Hi! I've got a database with one full-text index. Recently, it's started to misbehave. The other day I was alerted to a problem where the full-text population had stalled in the PAUSED state after only about 10% of the required rows had been indexed. The machine where this is running has pl...more >>