Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesDear 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
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread