Re: Best method to store and retrieve large files in database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Sherwood wrote on Mon, 31 Jul 2006 16:50:02 -0700:

for the PDF files. The downside to this (and of what I'm doing today) is
that I'm not really able to take advantage of any of the great indexing
and data mining capabilities of SQL.

You could write a custom iFilter so that SQL FTS can index the files in the
directory structure but treat them as though they are in the row, or there
might be a way of querying Index Server from within SQL to allow you to
search the external files and link the results to your SQL data.

Dan


.



Relevant Pages

  • Permissions problem (I think)
    ... running against a SQL 2000 DB. ... data from 2 external files into 2 seperate tables. ... shown as the owner. ... table it fails b/c it is empty. ...
    (microsoft.public.sqlserver.security)
  • Re: Using Design View versus SQL Statement View
    ... John F wrote in ... Mostly, I don't give a rat's ass how the SQL is formatted, because I ... format I specify remains intact. ...
    (microsoft.public.access.queries)