469,331 Members | 1,781 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

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
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

Apr 7 '06 #1
0 1192

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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.