searching entire database using Full-Text Catalog

[ksbrace]

I am trying to do a search on all the tables that I have indexed, but I am not succeeding. Is this possible? If so what is the syntax for the query? Thanks

 

[JayKusch]

May want to take a look at this link for some ideas ...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_fullad_3bs2.asp

Thanks

J. Kusch

 

[ksbrace]

Jay,
Thanks...I have the database, tables and columns all set up, but I seem to only be able to search one table at a time, I would like to search all tables for the keywords that are entered in hte search text field. Like this:
Select 'something' from 'tableName' where contains(mySearchCatalog, 'keyword') I would like to search the entire db, instead of just one table. thanks

 

[JayKusch]

I do not believe that is possible.

Thanks

J. Kusch