Searching Index Server and Sql Server in the same query
Posted on 2005-05-13
I need to quickly know if its possible to use the same search query to search both a database table and files in a specified folder.
I have a site which has both dynamic and flat pages, so when searching i need to be able to search the database and any flat pages within a given directory. I am able to search the database and using index server i have been able to freetext search the directory, however what i need to know is if there is any way of combining the two searches into one query.
I want to be able to fire off one request and get results from both SQL Server and Index Server. Is there any way of doing this?
Any help would be great.