"shank" <shank@tampabay.rr.com> wrote in message
news:eWzvU953DHA.2136@TK2MSFTNGP12.phx.gbl...
> I finally got my local SQL Server setup and created my first catalog. That
> catalog has 3 tables in it. I'm just trying some simple searches without
> success.
>
> -- This query syntax checks out OK, but yields no results.
> SELECT OrderNo, Description
> FROM Stock
> WHERE FREETEXT(Description, 'Amplifier')
>
> -- This query yields 2 results, which is correct.
> SELECT OrderNo, Description
> FROM Stock
> WHERE Description = 'Amplifier'
>
> What am I doing wrong with FREETEXT? I assumed I could type an exact match
> and get results.
> thanks
>
>

"John Kane" <jt-kane@comcast.net> wrote in message
news:OrKcow63DHA.3216@TK2MSFTNGP11.phx.gbl...
> shank,
> There maybe a couple of issues here... First of all, what is the exact
> version of SQL Server you are using? Could you post the full output of:
> SELECT @@version -- as this is helpful in troubleshooting SQL FTS
issues...
>
> Secondly, after you created the FT Catalog, did you run a Full Population?
> and if so, what that population successful? You should review your
server's
> Application event log for "Microsoft Search" source events to confirm if
the
> Full Population was successful.
>
> Regards,
> John
>
>
>
>
> "shank" <shank@tampabay.rr.com> wrote in message
> news:eWzvU953DHA.2136@TK2MSFTNGP12.phx.gbl...
> > I finally got my local SQL Server setup and created my first catalog.
That
> > catalog has 3 tables in it. I'm just trying some simple searches without
> > success.
> >
> > -- This query syntax checks out OK, but yields no results.
> > SELECT OrderNo, Description
> > FROM Stock
> > WHERE FREETEXT(Description, 'Amplifier')
> >
> > -- This query yields 2 results, which is correct.
> > SELECT OrderNo, Description
> > FROM Stock
> > WHERE Description = 'Amplifier'
> >
> > What am I doing wrong with FREETEXT? I assumed I could type an exact
match
> > and get results.
> > thanks
> >
> >
>
>