hi FTS gives me no results all the time. from the beginnning i have created table with columns: ImageColumn (Image), document_type(varchar(4)) and filepath(varchar(200)) i have created FullTextIndex on column ImageColumn and type - document_type. no i have an application which convert do...more >>

Hi, I have a problem with the FullText logfiles. I have 1 file (SQLFT0001500005.LOG) which is 1.2Gb. I want to delete (or at least shrink) this file, and move it to another diskdrive but I don't know how to... Regards, Martijn ...more >>

Hello, I have an issue with Dtsearch - I have very large .pdf documents in excess of 4000 pages that I am using Dtsearch to index. It seems that around the 4000 mark Dtsearch stops indexing and does not display any error message. I have tried adjusting memory size availability and nothing s...more >>

I am trying to get the full-text search thesaurus to work in Sql Server 2005 Express edition. I live in the USA so I assume the tx.ENU.xml is the appropriate file to modify. I used Notepad to modify the tx.ENU.xml file and saved as unicode: <XML ID="Microsoft Search Thesaurus"> <thesa...more >>

I am trying to create a full text search which allows users to choose such things as "with this exact phrase" , "with all of these words" AND "Without these words" etc. I tried using freetexttable command to search through the columns which was fine but it did not exclude the words that w...more >>

Hi SQL group, I am having a major issue with search and fulltext indexes. Here is the code I am using to add a fulltext to the User table: CREATE FULLTEXT INDEX ON dbo.[User] ( LastName ,FirstName ,EmailAddress ,Lo...more >>

I am getting the above error message from MOM 2005. Microsoft Cluster Service 'SQL Server Group' - 'SQL Server Fulltext' State. Cluster Service health check. Can anyone help with a solution?...more >>

I have a SQL Server 2005 with SP2 and when use the FTS, a could observe that AND and NEAR opertors are returning exactly the same results. Anyone has any ideas? Tanks in advanced...more >>

I am trying to create a full text search that uses a web interface similar to google's advanced search, which allows users to choose such things as "with this exact phrase" , "with all of these words" , "Without these words" etc. When i use the "containstable" keywords it seaches each column ...more >>

I have a client which this solution sounds perfect for: Does anyone know a web site that I can test the "Full Text Search Against PDF Blobs" functionality against. The website "layout design guy" is saying that SQL 2005 will be too slow and we should use "Lucene", an open source indexer in...more >>

I was wondering if this was possible. We have many databases on this cluster and I would like to isolate sharepoint network traffic to a dedicated nic. My thoughts is to create new cluster resources for an ip-address and network name and create a DNS alias like 'SharepointDB' that points t...more >>

My client is trying to use SQL Server Full Text Search to search PDFs stored in a varbinary(max) column. Full text search works fine for other Microsoft Office documents stored in the same table but it does NOT give back any results from the PDF documents. Following is a high-level view of ...more >>

Hi, I have a Photo Database, with a Photo table. Each photo has several Varchar fields for storing caption, description, keywords, etc. I have a Full-Text index/catalog for these fields. This is the problem: I want to find all photos that are related to "Simon" and "Jane", but no photos ta...more >>

I have a SQL 2000 full text catalog with Incremental population and Change Tracking. There is a replication job on the table , which replicates every 10 minutes. Sometimes there is a delay from the time the data appears in the table , to the point it appears in Full text catalog. Is there a...more >>

I have come across a problem. I cannot find the answer here, though I'm surprised nobody else has asked. The question is: How should one get SQL FTS to index files' content which have a suffix/extension not among those supplied by default BUT perfectly searchable by existing filters? I do *n...more >>

Hi, I am using an FT index on a column (varchar(4000) with an average length of 100) in a table that contains about 1 million rows. My tiny performance test looks like declare @t datetime set @t = getdate() select count(*) from containstable(table_name, expression, '"searchthis*"') pri...more >>