I have several file in .doc, .xls, .pdf and would like to know if SQL Server can do a full-text indexing on these files? These are files are stored on different locations in th harddisk.
Thank you for your reply.
Now we may separate the file system search by programming language like VC# or VB.
I have another question that is I want to do a full-text search on pubs database. I can setup a catalog and include table columns in the catalog, but the problem is I got empty result set. I was told the Windows Indexing Service was started by Local System, yes, I checked the Services it was used/started by Local System, so I may need to give more permission to this Local System on SQL Server. But I don't know how to do that?