Contains Not Working

Hello,
I have done the following as per BOL on a text field
EXEC sp_fulltext_database 'enable'
EXEC sp_fulltext_catalog 'TextSearchBody',
'create'
EXEC sp_fulltext_table 'NewsItems',
'create',
'TextSearchBody',
'PK_newsItems'
EXEC sp_fulltext_column 'NewsItems',
'Body',
'add'
EXEC sp_fulltext_table 'NewsItems',
'activate'
GO
EXEC sp_fulltext_catalog 'TextSearchBody',
'start_full'
After doing this the query
SELECT body
FROM newsitems
WHERE contains (body, 'Triumph' )
does not return any rows.
Any idea what else can I do to get it working. All help appriciated.
1) check the application log in event viewer for any messages from MSSearch
or MSSCI.
2) issue the below queries in your full text enabled database.
select FULLTEXTCATALOGPROPERTY('TextSearchBody','populate _status')
go
select FULLTEXTCATALOGPROPERTY('TextSearchBody','ItemCoun t')
go
select FULLTEXTCATALOGPROPERTY('TextSearchBody','UniqueKe yCount')
go
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Anoop" <Anoop@.discussions.microsoft.com> wrote in message
news:3DE601E2-ACA0-4789-ACE7-E42F5945AC73@.microsoft.com...
> Hello,
> I have done the following as per BOL on a text field
> EXEC sp_fulltext_database 'enable'
> EXEC sp_fulltext_catalog 'TextSearchBody',
> 'create'
> EXEC sp_fulltext_table 'NewsItems',
> 'create',
> 'TextSearchBody',
> 'PK_newsItems'
> EXEC sp_fulltext_column 'NewsItems',
> 'Body',
> 'add'
> EXEC sp_fulltext_table 'NewsItems',
> 'activate'
> GO
>
> EXEC sp_fulltext_catalog 'TextSearchBody',
> 'start_full'
> After doing this the query
> SELECT body
> FROM newsitems
> WHERE contains (body, 'Triumph' )
> does not return any rows.
> Any idea what else can I do to get it working. All help appriciated.
>
>
|||Hillary,
I have looked at the event log and there are warning in the log and the details are as follows
Event id :3024 , category : gatherer
and discription :The crawl for project <SQLServer$TST1 SQL0002600005> could not be started, because no crawl seeds could be accessed. Fix the errors and try the crawl again.
Also the output of the Select statements is as follows
select FULLTEXTCATALOGPROPERTY('TextSearchBody','populate _status')
go
NULL
select FULLTEXTCATALOGPROPERTY('TextSearchBody','ItemCoun t')
go
0
select FULLTEXTCATALOGPROPERTY('TextSearchBody','UniqueKe yCount')
go
1
Please let me know if you need more info.
Thanks
"Hilary Cotter" wrote:

> 1) check the application log in event viewer for any messages from MSSearch
> or MSSCI.
> 2) issue the below queries in your full text enabled database.
> select FULLTEXTCATALOGPROPERTY('TextSearchBody','populate _status')
> go
> select FULLTEXTCATALOGPROPERTY('TextSearchBody','ItemCoun t')
> go
> select FULLTEXTCATALOGPROPERTY('TextSearchBody','UniqueKe yCount')
> go
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Anoop" <Anoop@.discussions.microsoft.com> wrote in message
> news:3DE601E2-ACA0-4789-ACE7-E42F5945AC73@.microsoft.com...
>
>
|||Hi Hillary,
I have now checked the error on MSDN and changed the login account being used to start the search and it seems to be all working.
Thanks for the help.
Anoop
"Hilary Cotter" wrote:

> 1) check the application log in event viewer for any messages from MSSearch
> or MSSCI.
> 2) issue the below queries in your full text enabled database.
> select FULLTEXTCATALOGPROPERTY('TextSearchBody','populate _status')
> go
> select FULLTEXTCATALOGPROPERTY('TextSearchBody','ItemCoun t')
> go
> select FULLTEXTCATALOGPROPERTY('TextSearchBody','UniqueKe yCount')
> go
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Anoop" <Anoop@.discussions.microsoft.com> wrote in message
> news:3DE601E2-ACA0-4789-ACE7-E42F5945AC73@.microsoft.com...
>
>