Wired problem with sql query - 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

General SQL Server Forums

New to SQL Server Programming

Wired problem with sql query

Author

Topic

bluestar
Posting Yak Master

133 Posts

Posted - 2008-07-31 : 12:14:48

Hello

I am facing a strange problem.I am connected to my server, and when I am executing query say Select ElementText From TextElement.... its executing fine,

BUT When I am Using word freetext or contains in the select statement
like
Select ElementText
From TextElement
Where
Contains (ElementText,'"test"');

The query is not showing any error but its not executing at all.

Only thing it says is "Executing Query".....for hours.....

I dont understand what the reason behind this.

""Initially my query was working fine on my system,but suddenly from yesterday I am facing this problem.""
Its making problem only when I am using Freetext or contains.

Please help me out.What suddenly might have gone wrong????

Thank You

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-07-31 : 12:33:11

Could you confirm that the Full text componet is running OK?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

bluestar
Posting Yak Master

133 Posts

Posted - 2008-07-31 : 12:36:17

Thank for reply.Can you tell me what do you mean by Full text Component??

I mean I have created Catalog ,indexes...and all

bluestar
Posting Yak Master

133 Posts

Posted - 2008-07-31 : 13:10:22

please help me ..how to resolve this problem.non of my full text query is working.
I tried executing some queries again...
when I execute
CREATE FULLTEXT CATALOG charlottecatalog
it says this catalog already exist..as I creates it.
CREATE Unique Index ui_TextElement on TextElement(SystemElementID)

it says index already exist ...as I created it before

Create fulltext index on TextElement(ElementText TYPE COLUMN ntext )
Key index ui_TextElement on charlottecatalog
with change_tracking auto

BUT in this case again it says "Executing query"...and no result!!!!

what could be the possible reason for this......I am badly stuck...as due to this I cannot proceed my task...

Please help

Thank You.

mfemenel
Professor Frink

1421 Posts

Posted - 2008-07-31 : 13:19:47

Full text is a service under the management section in EM. Is the service running?

Mike
"oh, that monkey is going to pay"

bluestar
Posting Yak Master

133 Posts

Posted - 2008-07-31 : 13:36:53

Yes I found FullText Search,but only thing I can do is refresh.
If I click on that icon,nothing happens.

Please do reply

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources