Hi there,

I've created an FTS Catalog based off an indexed view.  For example
purposes, say it has two columns: Name, Description.

Is it possible to perform one query that will search both columns, but have
them weighted differently (ie: Name carries much more weight than
Description)?

Or is the only way to do this would be to roll my own "Best-Bets" type query?

Thanks,
D.

You have a discussion group for FTS. Maybe you should try it there.

Are you saying there is a managed newsgroup for FTS?  If so, and if you have
a direct line to Microsoft, it would be super if you could tell them to
update their web-based newsreader to include it in the list.

Show quoteHide quote

On Thu, 13 Jul 2006 11:05:02 -0700, E60 wrote:

Hi E60,

Yep - microsoft.public.sqlserver.fulltext. Or if you prefer the
web-based version:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.fulltext&lang=en&cr=US

Interesting.. I 'hacked' the managed newsgroups URL as follows:
http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.fulltext

And now it shows up in the drop down box (but only when I do that).

Whatever the case, thanks, I'll move my question there.

Show quoteHide quote

How can I Rearrange my Data
tring’
Query taking long-long time
Timestamp in User-Defined Function Causes Error
Circular Autonum Keys