Storing and searhing MSWord docs in SQL Server

• jcoelho

  SSC Rookie

  Points: 33

  More actions

  April 2, 2002 at 3:01 pm

  #78501

  I came across this feature mentioned whereby you can store Word documents and conduct full text searches on the documents. I would appreciate any help (SQl script to store the docs and search) as I need to build such an application using .asp pages.

  Thanks in advance

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 2, 2002 at 4:15 pm

  #426500

  Usually easier to use the ADO stream object to load/retrieve images. Just saw a post today with sample code:

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3356&FORUM_ID=9&CAT_ID=1&Topic_Title=Working+with+images&Forum_Title=General

  Andy

  Andy
  Connect with me on LinkedIn

• jcoelho

  SSC Rookie

  Points: 33

  More actions

  April 3, 2002 at 12:45 pm

  #426556

  Thanks Andy!

  I've also bought a book on SQL Server 2000 and am going through Books Online. Let's see how far I get.

  Thanks again

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 3, 2002 at 1:42 pm

  #426557

  No problem! Visit often, good questions make for an interesting site!

  Andy

  Andy
  Connect with me on LinkedIn