sql server full text search: Storing word file in SQL Server 2000 and searching words using SQL Query -- sql server full text search

Re: Storing word file in SQL Server 2000 and searching words using SQL Query

John Kane
11/21/2003 8:32:13 AM

sql server full text search:

Pranita,
If you cannot use a CONTAINS or FREETEXT predicate on column 'Document'
because it is not full-text indexed, then this will not work. If you want to
use CONTAINS or FREETEXT, you must Full-Text index the column Document.

The only other alternative is to use Windows 2000 Server / Windows Server
2003 and the Indexing Service (IS) to "full-text index" the documents on
your server's hard disk drive and then use the MSIDX OLE DB Provider for
Microsoft Indexing Service and create a Link Server to IS via
sp_addlinkedserver. Howver, in past posts it has been noted that this method
does not perform as well as FT Indexing the documents inside SQL Server.

Regards,
John

[quoted text, click to view]

Storing word file in SQL Server 2000 and searching words using SQL Query

Pranita
11/21/2003 4:52:39 PM

Hi John,

Thanx for the reply. But still I am not getting the output.

Table Name: test_a
Fields are:
ID Int 4 - Primary Key
Name nvarchar 100
Document Image 16 Null

Full Text Indexing is done on Name field but I want to retrive output on
Document [i.e Image field on which Full Text Indexing is not possible.]

So i fire following query i.e.

SELECT ID,NAME,DOCUMENT from test_a WHERE CONTAINS(DOCUMENT,'"madhuri"')

Output:
Cannot use a CONTAINS or FREETEXT predicate on column 'Document' because it
is not full-text indexed.

If possible please suggest me the solution.

Thanxs and Regards,

Pranita.