472,102 Members | 1,989 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,102 software developers and data experts.

Full-text Search applied on a View

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

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

Apr 7 '06 #1
0 1251

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by daking | last post: by
reply views Thread by reneecccwest | last post: by
7 posts views Thread by alexcn | last post: by
2 posts views Thread by Larry R Harrison Jr | last post: by
2 posts views Thread by Lee | last post: by
11 posts views Thread by rh00667 | last post: by
5 posts views Thread by =?Utf-8?B?TWFydHluIEZld3RyZWxs?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.