Home > IT Answers > SQL Server > Fulltext Search - SQL Server 2005 SP2
Repo
5 pts.
Q:
Fulltext Search - SQL Server 2005 SP2
SQL Server Full Text Search, SQL Server 2005, FTP Server, SQL Server 2005 administration
I am new to the SQL Server 2005 Fulltext search technology and I have not tried it yet myself.
I would like to ask about availability of a feature which is provided for example by the Oracle Text technology which is indexing documents using FTP protocol.

I have various formats of text documents residing on the FTP server. I need to create a fulltext index over these files to enable fulltext search of their content:
- Is it possible to create a fulltext index over this files wihtout the need of the permanent local copy of files?
- If yes, is there any limitation which I should be aware of when creating context index over files which resides on FTP server? (file size limit, supported file types limitation)
- Is any incremental indexing possible(when I add new files to the FTP server I do not have to rebuild the whole index)?

Regards,

Michal
ASKED: May 7 2009  9:57 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
Mrdenny
50675 pts.
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • Bookmark and Share
SQL Server full text indexing doesn't allow for indexing files outside of the database. They would need to be loading into a table within the database for the SQL Server to index. You can use the Windows 2003 Indexing service to index files on a file server, however it doesn't support indexing files on an FTP server. You would need a local copy of the files in question, or the ability to access the files over a Windows File share.
Last Answered: May 16 2009  3:46 AM GMT by Mrdenny   50675 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _