Full text search by table
How do I enable and execute "full text" lookups in a table in SQL Server 2005?
I didn't quite understand the solution in: How to Use Full-Text Search on Multiple Tables, SQL Server 2005
-1
source to share
4 answers
I think this video tutorial should be a good part for you.
you need to set up the index before you can search for it.
0
source to share
Start with Configure SQL Server 2005 Full-Text Search .
Then go through an overview of 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
-1
source to share