How to enable and perform a "full text" search on a table in SQL Server 2005?
I did not quite understand the solution in: How do I use full text search across multiple tables, SQL Server 2005
How to enable and perform a "full text" search on a table in SQL Server 2005?
I did not quite understand the solution in: How do I use full text search across multiple tables, SQL Server 2005
I think that this video tutorial, should get you a good part of the way there.
you have to setup the index before you can search against it.
You can also have a look at http://msdn.microsoft.com/en-us/library/ms142583.aspx
Begin to Set Up SQL Server 2005 Full-Text Searching.
Then do an overview about the functions you can use:
http://forta.com/blog/index.cfm/2007/1/4/Performing-SQL-Server-CONTAINS-Searches
http://forta.com/blog/index.cfm/2007/1/4/Performing-SQL-Server-FREETEXT-Searches
http://www.forta.com/blog/index.cfm/2007/1/5/Ranking-SQL-Server-2005-FullText-Search-Results