 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / November 2006full text body search not finding all results
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 search it doesn't find it. I have full text-catalog enabled on the database. I've tried deleting and re-creating the catalog but still the same thing. The question is are they really there or are they being indexed. Use a like to verify that it is really there. If it is then it is a problem with it being indexed. Review the gatherer logs to see if it indexes the rows correctly.  SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com >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 [quoted text clipped - 5 lines] > > I've tried deleting and re-creating the catalog but still the same thing. That's what my problem is, it's not being indexed correctly. How do I fix that?? > The question is are they really there or are they being indexed. > [quoted text clipped - 11 lines] > > > > I've tried deleting and re-creating the catalog but still the same thing. Can you see if there are any errors in the gatherer logs? If not can you send some of the problem docs to me offline or post them here? Send me the originals before they went into the database. SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > That's what my problem is, it's not being indexed correctly. > [quoted text clipped - 19 lines] >> > I've tried deleting and re-creating the catalog but still the same >> > thing. I'm new to SQL so I'll need some help here. 1. How do I get gatherer logs?? 2. When you say problem docs, what do you mean exactly?? (these are test emails). > Can you see if there are any errors in the gatherer logs? If not can you > send some of the problem docs to me offline or post them here? Send me the [quoted text clipped - 23 lines] > >> > I've tried deleting and re-creating the catalog but still the same > >> > thing. You can find the gatherer logs on a SQL 2005 server in C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\LOG> Where X is your instance name. The gatherer logs themselves will look like this: SQLFT0001000015.LOG test email should be indexable in a char or varchar column. Attachments may not be depending on how you store them. Are you storing them in varbinary or image columns? Do you have a document type column associated with the image or varbinary columns? SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > I'm new to SQL so I'll need some help here. > [quoted text clipped - 35 lines] >> >> > I've tried deleting and re-creating the catalog but still the same >> >> > thing. Ok, I'll look at them. I assume I just open them with Notepad. What am I looking for?? As far as your questions: 1. Not sure if they're being stored in verbinary or image columns. However this GFI Mail Archive stores it. 2. Don't know if I have a document type column associated with the verbinary or image columns. > You can find the gatherer logs on a SQL 2005 server in C:\Program > Files\Microsoft SQL Server\MSSQL.X\MSSQL\LOG> [quoted text clipped - 49 lines] > >> >> > I've tried deleting and re-creating the catalog but still the same > >> >> > thing. Can you script out your table, indexes, and full text indexes and post them here. Key to solving your problem is discovering how the GFI archive stores it. If it is text, or msg you should be fine. If it is something proprietary you will be unable to index them. SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Ok, I'll look at them. I assume I just open them with Notepad. What am I > looking for?? [quoted text clipped - 71 lines] >> >> >> > same >> >> >> > thing. I went to the GFI web site and notice that their product does work with SQL FTS. Their technical support group should be able to help you through this problem. SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Can you script out your table, indexes, and full text indexes and post > them here. [quoted text clipped - 82 lines] >>> >> >> > same >>> >> >> > thing. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.