I do not think OWS can do this internally, however I was able to accomplish this with the following:
- Install MS Indexing Service on the webserver
- Create a catalog (index server);
- Create a link between SQL server and Index Server (TSQL sp_AddLinkedServer)
- Query as per usual in OWS!! That's right: a "regular" query!
Sample TSQL to create the link between services:
EXECUTE sp_AddLinkedServer [ServerName],
Sample query for OWS:
'SELECT Directory, FileName, DocAuthor, Size, Create
WHERE CONTAINS( Contents, ''[StringToFind]'' ) ' )
[ServerName] can be any string you chose
[CatalogName] is the name you used when creating the Catalog
[StringToFind] is the string you are searching for;
Mind the single and double quotes.
As far as I can tell, Creating virtual directories in IIS is optional; I didn't and everything still worked.
There may be (and when I say "may be" I mean "are") some security concerns; know what you are doing; use at your own risk.
Installing Index Server
Creating a catalog
Textual Searches on File Data
How to use an ASP.NET application to query an Indexing Service catalog by using Visual Basic .NET
I'm not on this forum regularly so if you have a question it may be awhile before I get back to you.