Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 How to perform full-text search on many tables?

Author  Topic 

Tiendq
Starting Member

4 Posts

Posted - 2005-04-07 : 00:54:42
Hi,

I want to perform full-text search on all tables in my website (a portal), how to do that? and how to know what is table which each record in search result belonged to?

Thanks,

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-04-07 : 06:11:23
you need to full-text index the tables you want to search in.
what are you trying to do exactly?


Go with the flow & have fun! Else fight the flow
Go to Top of Page

Tiendq
Starting Member

4 Posts

Posted - 2005-04-07 : 22:22:24
thanks, but how to write the SQL query? CONTAIN and FREETEXT not support many tables name, right?
Go to Top of Page
   

- Advertisement -