contains - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

contains

Author

Topic

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-19 : 10:34:53

when I do a free text search on one character with a space on either side I get:
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. A clause of the query contained only ignored words.

Any ideas on how I solve this one anyone?

and no, I'm not Japanese...

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-19 : 10:39:05

It's a noise word. That's the first time I've had to deal with that one. Guess I got to take it out the list now.

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-19 : 11:24:05

One thing though,

I have to edit the noise.eng file. But I can't because windows says it is in use.
This is on a live server, so I need to be sure on how to solve this.
If I stop the SQL Server Service, will that release the reference to the file so that I can edit it?

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-07-19 : 12:19:45

I would think that you SHOULD be able to stop the FTS, independant of stopping SQL server.
Only service not available therefore to the users would be FTS (indexing??)

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-20 : 03:57:07

The Indexing Service is not started.
There is no such thing as a FTS service to my knowladge.
This one has me stumped.

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-07-20 : 06:33:05

sorry...terminology mixup...I was equating FTS with the Indexing Service

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-20 : 10:39:28

I'm gonna have to try and stop the server service then. and see what happens.
really didnt want to try that
seems unnecesary
dont know what's causing it
it doesnt happen on my test system

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-20 : 12:38:46

darn.
stopped sql server but that made not difference
in trying to work out what the problem is, I tried renaming the file. But it says there is a sharing violation, the file may be in use...

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-20 : 12:48:36

got it! It was the MS Search service that I needed to stop!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources