I'm looking to implement a more robust search engine on an existing ASP.NET app. The application allows uploading of documents (word, excel, etc) and stores the files on a directory, and also inserts a row into SQL Server table, lets call the table 'files'. it stores information about the documents such as filesize, type, filename, etc.
My question is.... using Index Server (which I have not had the pleasure of doing up till now) will it be possible to query the Index Server catalog thru a SQL stored procedure, and do a JOIN on other tables (ie my 'files' table.) to check for permissions, etc
For instance, (pseudo code)
SELECT something FROM IndexServerCatalog as ISC on blah blah..
JOIN FILES as F on ISC.DocumentTitle = F.DocumentTitle AND F.CreatedBy = @CreatedBy