October 28, 2011 at 12:54 pm
Hmm... I blew this one. However, MSDN does not support that "Also, sp_fulltext_database cannot (and should not) be used to enable/disable full-text search."
Cf. description of sp_fulltext_database at http://technet.microsoft.com/en-us/library/cc721269(SQL.100).aspx#_Toc202506258.
Seems funny that you can disable a feature but it still works.
October 31, 2011 at 5:34 am
Good question and a lot of great discussions. Thanks for submitting.
http://brittcluff.blogspot.com/
October 31, 2011 at 5:56 am
Hmm... that's interesting.
You can disable the full-text feature by accessing the database facets... but I didn't know that you couldn't disable the full-text SEARCH.
[edit] That options does nothing. Now I get it. Thanks.
Well, thank you for the question.
Best regards,
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA
October 31, 2011 at 9:42 am
Interesting question. I blew this one but learned something. Thanks!
October 31, 2011 at 7:31 pm
DugyC (10/28/2011)
Although, like 71% (at this time) of the others, I got this wrong because I was thinking Full-text indexing on a table can be disable/re-enabled. The question, on re-reading, is unambiguous in that it quite clearly talks about full text search on a database.
I did not even know that it was two different thing. I thought that full-text search was a search on the full-text indexing :crazy:
Too much to learn in SQL... but very nice to always have something to learn :satisfied:
Thanks!
November 1, 2011 at 12:33 pm
November 26, 2012 at 9:13 pm
Hi there,
I have something to ask. When I stopped my SQL SERVER FULL TEXT SEARCH and I going to Start it again there was a problem? "The request failed or the service did not respond in timely fashion, consult the event log or other applicable error logs for details".
please help me to solve this error,
thanks
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply