Microsoft SQL Server forum - Full-text Search applied on a View

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Full-text Search applied on a View

coosa

2006-04-07, 8:25 pm

Dear all,

I'm using MS SQL Server 2005 and i have a full-text search issue;
Let's say i have table1, table2 and table 3; for each, some full-text
indices have been created.
The issue is that i created a view which joined the three tables and i
attempted to perform a full-text search on that view, but that resulted
in an error indicating that a "unique column" is required for that
view.

Indeed, table1, table2 and table3 are linked together with many to many
relationships so that there are other weak entities between them, for
such duplications are allowed.

Hence, the view would show duplicate PK's.
How do i perform a full-text search on a view as described above?

Best regards

Sponsored Links