Saving a full text index to SQL server

Does anyone know a good solution to this problem?

I have a large filestore of all sorts of documents (word, PDF, OCR document scans, emails, etc)

I have a large SQL database that defines each of these documents (folder, parent folder, document owner, etc, etc)

I need to do combined searches over the full text of each of the documents, combined with the descriptive data of the documents that is stored in the SQL server.

Now, normally I would just use a distributed query to query both the index server and the SQL server. However I'm using a JDO enhancer to perform the query and this requires all the data to be contained within the SQL server.

Can I get the Index server to create its index in SQL tables?

Is there another way to combine the structured and unstructured data within SQL server.Hey

U can use a OPENQUERY to query on INDEX SERVER. the result of that query can be used in a SQL Server query.

To use this option you need to create a RemoteServer which redirects to a Index Server catalog.

Example:

SELECT P.Id,
P.Name,
Q.FileName,
Q.Path
FROM ( OPENQUERY(RemoteServerName,
SELECT FileName,
Path,
Write,
Rank,
etc etc
FROM SCOPE ( "e:\documents" )
WHERE CONTAINS(Contents, 'searchword')
)
AS Q INNER JOIN P ON P.Id = Q.ID
)

Greetz Da Witte