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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-04-01 : 08:10:30
|
| How do you insert a doc file into image column? Cant seem to find any documentation or google on it.Do you provide the path? or how does it work? |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-04-01 : 08:26:36
|
| Why do you want to do this?"Store the document in the file system and just keep a pointer to its location in the database. This will save you lots of pain."-------Moo. :) |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-04-01 : 08:44:11
|
| I want to be able to do a full-text search on thousands of word documents. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-04-01 : 08:57:20
|
| I believe you can use the ADO Stream Object to send files to stored procedures.This article might be helpful, or search for help with google:http://www.betav.com/Files/Content/Whitepapers/Using%20the%20ADO%20Stream%20Object%20to%20Manage%20BLOBs.htmCODO ERGO SUM |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-04-01 : 09:13:53
|
| Wow that's easy.Better not do it though.Not best practice.Now I gotta work out how best to full-text index a directory with a set of sub directories so that I can just store a pointer in the database instead.That is a good idea isnt it? Full-text index a directory I mean.Would you still be able to query that simply though? Could you still search for all people that have certain text in their doc files on the hardrive and return the text of the doc in a column in the query next to the PersonID column for example? |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-04-01 : 09:41:59
|
| Is it really necessary to direct sarcasm at people who are trying to help you?That seems to be counterproductive if you want to get help in the future, and someone doesn’t answer your question because they were offended the last time.CODO ERGO SUM |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-04-01 : 10:14:36
|
| ok ease up michaelsarcasm? where??? i dont know what you're talking abouti dont have time to be sarcastic!! i'm too busy working!anyway, professionally moving on...It seems that Microsoft Indexing Service & Microsoft Search service will do the trick. Has anyone here tried it out in the real world with gigs and gigs of files? |
|
|
|
|
|
|
insert doc file into image column