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.
| Author |
Topic |
|
bluestar
Posting Yak Master
133 Posts |
 Posted - 2008-08-04 : 10:46:33
|
| hello,Non of my full text queries are working.when ever I try to execute sql query with freetext or contains,it does not show any result.It keep on saying executing query without showing any result.I am facing this problem from last Thursday before that my search queries were working fine and showing correct result.I dont understand what could have gone wrong.I also checked sql server configuration manager,there full text search state is showing running.when I try to run it in visual studio with interface,it says that Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.I am sure that my server is working fine.Please help me,how to resolve thisThank You |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-04 : 10:47:50
|
| have you set up full text index correctly? |
 |
|
|
bluestar
Posting Yak Master
133 Posts |
Posted - 2008-08-04 : 10:52:32
|
| yes,This is what I have done and I tried executing some queries again...when I executeCREATE FULLTEXT CATALOG charlottecatalogit 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 beforeCreate fulltext index on TextElement(ElementText TYPE COLUMN ntext )Key index ui_TextElement on charlottecatalogwith change_tracking autoBUT 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 helpThank You. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 23:31:37
|
| Did you populate the catalog yet? |
|
|
|
|
|
|
full text queries not working