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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-07 : 08:39:47
|
| James writes "Hello. Thanks for looking at this question.I've built a stored procedure which searches within an OPENQUERY for Indexing Services on Windows 2000. I have no problems looking within .doc, .xls, .ppt types of files and finding results. For example: proc_search 'yak' would result in a table containing columns filename, path, characterization, author.The only caveat to this method is that I'm unable to return the contents of the file.My question to you is, how can I extend my search stored procedure to return a snippet of the actual contents within a document? My results would be much akin to the 'google desktop search'. The example below shows what I'm hoping to do, with the word 'development' bolded to show as search term.proc_Search 'development'Contents of #results:FILE: Runbook.docCONTENT: OLAP Database Development blahblahPATH: C:\jcat\Runbook.docSo far I have tried doing a bulk insert, dynamic BCP statement and next I'm going to try and make a dynamic DTS. Perhaps to answer this, I just need to know if I can import a DOC/XLS/PPT file through a filter or parser into a SQL table so that the contents are intact.Thanks again for your time." |
|
|
|
|
|
Advanced Search with FullText and Indexing Service