Searching Index Server and Sql Server in the same query

Posted on 2005-05-13
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
    LVL 9

    Expert Comment

    Hi bcops,

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


    Author Comment

    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.

    LVL 9

    Accepted Solution

    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

    Fine with me - thanks.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    no14 challenge 14 47
    fix34  challenge 9 73
    VBA color chart bars 12 51
    firstChar challenge 13 60
    This is an explanation of a simple data model to help parse a JSON feed
    Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now