"Gilbert" <Gilbert@discussions.microsoft.com> wrote in message
news:BD072397-C5D4-4B19-A8E6-80C03AF1784E@microsoft.com...
> 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.
>
> "Hilary Cotter" wrote:
>
>> 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?
>>
>> --
>> Hilary 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
>>
>>
>>
>> "Gilbert" <Gilbert@discussions.microsoft.com> wrote in message
>> news:1F6F0D54-F9FB-4CC3-A8D3-E0445883AE00@microsoft.com...
>> > 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).
>> >
>> > "Hilary Cotter" wrote:
>> >
>> >> 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.
>> >>
>> >> --
>> >> Hilary 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
>> >>
>> >>
>> >>
>> >> "Gilbert" <Gilbert@discussions.microsoft.com> wrote in message
>> >> news:5FEDEB29-BE51-4733-8224-58C87AEAED5C@microsoft.com...
>> >> > That's what my problem is, it's not being indexed correctly.
>> >> >
>> >> > How do I fix that??
>> >> >
>> >> > "Hilary Cotter" wrote:
>> >> >
>> >> >> 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.
>> >> >>
>> >> >> --
>> >> >> Hilary 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
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Gilbert" <Gilbert@discussions.microsoft.com> wrote in message
>> >> >> news:1813FDF8-E095-4784-B9B8-707C8309B1C9@microsoft.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
>> >> >> > "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.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23lkK28IEHHA.3520@TK2MSFTNGP04.phx.gbl...
> 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.
>
> --
> Hilary 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
>
>
>
> "Gilbert" <Gilbert@discussions.microsoft.com> wrote in message
> news:BD072397-C5D4-4B19-A8E6-80C03AF1784E@microsoft.com...
>> 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.
>>
>> "Hilary Cotter" wrote:
>>
>>> 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?
>>>
>>> --
>>> Hilary 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
>>>
>>>
>>>
>>> "Gilbert" <Gilbert@discussions.microsoft.com> wrote in message
>>> news:1F6F0D54-F9FB-4CC3-A8D3-E0445883AE00@microsoft.com...
>>> > 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).
>>> >
>>> > "Hilary Cotter" wrote:
>>> >
>>> >> 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.
>>> >>
>>> >> --
>>> >> Hilary 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
>>> >>
>>> >>
>>> >>
>>> >> "Gilbert" <Gilbert@discussions.microsoft.com> wrote in message
>>> >> news:5FEDEB29-BE51-4733-8224-58C87AEAED5C@microsoft.com...
>>> >> > That's what my problem is, it's not being indexed correctly.
>>> >> >
>>> >> > How do I fix that??
>>> >> >
>>> >> > "Hilary Cotter" wrote:
>>> >> >
>>> >> >> 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.
>>> >> >>
>>> >> >> --
>>> >> >> Hilary 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
>>> >> >>
>>> >> >>
>>> >> >>
>>> >> >> "Gilbert" <Gilbert@discussions.microsoft.com> wrote in message
>>> >> >> news:1813FDF8-E095-4784-B9B8-707C8309B1C9@microsoft.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
>>> >> >> > "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.
>>> >> >>
>>> >> >>
>>> >> >>
>>> >>
>>> >>
>>> >>
>>>
>>>
>>>
>
>