[Last Call] Learn how to a build a cloud-first strategyRegister Now


Searching Index Server and Sql Server in the same query

Posted on 2005-05-13
Medium Priority
Last Modified: 2010-04-17
Hi all,

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.

Question by:bcops
  • 2
  • 2

Expert Comment

ID: 13996770
Hi bcops,

 Short answer no, you can not span multiple database or datasource from a single query


Author Comment

ID: 13996918
Hi Cyberdevil,

Thanks for your prompt answer, but i'm sure i have seen something like this done before. Is there anything like this that anyone else has seen?

For example is there any way SQL Server can interact with Index Server allowing me to fire off a single call to a stored procedure which then runs two SQL queries, one to the sql tables and one to the index server instance?

I have other less desirable options available to me but i would idealy like to implement it in this manner.


Accepted Solution

cyberdevil67 earned 2000 total points
ID: 13997090
NO you can't do it, you can get info from 2+ different tables. But as a query is run against a database, you will need to seperate queries.

You could do a Stored Proc, but again these are run against the database they are designed for.

Author Comment

ID: 14186783
Fine with me - thanks.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Starting up a Project
Loops Section Overview

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question