Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pbz
Starting Member
2 Posts |
 Posted - 2007-10-26 : 09:12:11
|
| I'm using SQL 2005 (couldn't find a forum for SQL2005 developers) and I'd like to store some documents and setup the full text filters for Word/PDF/etc to be able to search for the content in these documents. The only downside that I see with this method is that it's going to use the memory for documents (cache) that I rarely need. I was wondering if it would be possible to use the full text filter and extract the text only version of those documents and store that instead -- it would take much less room. In this case the files themselves would stay in the file system. Any ideas on how to do this or am I worrying for nothing?Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-27 : 01:40:11
|
| What do you mean 'use the full text filter and extract the text only version of those documents and store that instead'? By the way, full text catalog is stored in file system. |
 |
|
|
pbz
Starting Member
2 Posts |
Posted - 2007-10-29 : 10:39:49
|
| I found the solution: IFilter[url]http://www.codeproject.com/csharp/IFilter.asp[/url]Thanks. |
|
|
|
|
|
|
Using Full Text filters without storing the data