full-text

Using Full-Text Search in SQL Server 2005 across multiple tables, columns

Hi, I have a problem, I created a full text search query which return a record(s), in which the paramater I have supplied match(es) in every fields(full-text indexed) of multiple tables. The problem is , when the user.id is equal to ceritification.AId it returns a records eventhough it was not satisfied with the parameter supplied. Fo...

Full Text Search in SQL Server 2005

Hi, I am working on the Full Text Search in Sql Server 2005. I have created a catalog and then an index on a particular table. I am searching for data using FREETEXTTABLE(tablename,*,@SearchKeyword). So I am searching in all columns in the index since any of the columns can contain the keywords. Is there is a way for me to know which ...