full-text index with multiple tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geekyguy - 05 Jun 2008 21:41 GMT

Hi All: I just stumbled across this post, noting that you can create a view
against multiple tables, and then use the view in the full-text index, so
that if you do a freetexttable query agains the view, you are in effect
searching multiple tables simulataneously.

http://versia.com/2008/02/06/sql-server-full-text-searching-across-multiple-tables/

This may be old news already, but I had previously been doing nested queries
against each table in the full-text index...this seems much more
straightforward...just curious if there are any problems or issues with this
method?

Reply to this Message

geekyguy - 05 Jun 2008 23:05 GMT

> Hi All: I just stumbled across this post, noting that you can create a
> view against multiple tables, and then use the view in the full-text
[quoted text clipped - 7 lines]
> straightforward...just curious if there are any problems or issues with
> this method?

OK, I ran into my first problem...after creating this view, I attempted to
update one of the tables that has a field in the view, I'm getting an error:

"UPDATE failed because the following SET options have incorrect settings:
'ARITHABORT'. Verify that SET options are correct for use with indexed views
and/or indexes on computed columns and/or query notifications and/or xml
data type methods."

Do I need to change the update statement to "set arithabort on" or does this
create a problem with the view? How do I set arithabort to "on" within the
context of an update statement

Reply to this Message

sql411@nospam.com - 26 Jun 2008 19:12 GMT

geekguy,
check out these articles from MS to reference as a checklist. mostly your
"set" options on your view and calling procs, as well as constraints.

http://msdn.microsoft.com/en-us/library/ms190019.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx

hth,
robert towne

Reply to this Message