InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 22:46:38 GMT20http://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxHi 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,thanksMon, 26 Nov 2012 21:13:34 GMTJezterlyne_softIDhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxlearned something i was not aware of....Tue, 01 Nov 2011 12:33:29 GMTBuntyBoyhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspx[quote][b]DugyC (10/28/2011)[/b][hr]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.[/quote]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!Mon, 31 Oct 2011 19:31:17 GMTtilew-948340http://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxInteresting question. I blew this one but learned something. Thanks!Mon, 31 Oct 2011 09:42:52 GMTKWymorehttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxHmm... 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,Mon, 31 Oct 2011 05:56:25 GMTcodebyohttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxGood question and a lot of great discussions. Thanks for submitting.Mon, 31 Oct 2011 05:34:11 GMTBritt Cluffhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxHmm... 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.Fri, 28 Oct 2011 12:54:46 GMTRevenanthttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxgood question - thanks!Fri, 28 Oct 2011 08:35:30 GMTOzYbOi d(-_-)bhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxhmmm...interesting question.Fri, 28 Oct 2011 08:29:42 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxNot the first time using SSMS help has steered me in the wrong direction. I'm learning.Thanks for the question.Fri, 28 Oct 2011 05:35:32 GMTThomas Abrahamhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxNice one, thanks IulianFri, 28 Oct 2011 04:32:44 GMTIulian -207023http://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxgood question!!! thanks!Fri, 28 Oct 2011 04:29:17 GMTrfr.ferrarihttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxWot DugyC sed. Fortunately I overrode my immediate impulse to get this one right!Fri, 28 Oct 2011 04:10:27 GMTcall.copsehttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspx[quote][b]ipounder (10/28/2011)[/b][hr]Good question, however the answer is a bit pedantic, so I'm going to be a bit pedantic in my comment. Whilst you can't disable full text search at the database level, you can achieve this in effect by disabling it at the table level, so if you do it on all tables, it is removed, is it not?:-)[/quote]I would say not... because if I then add a full text index to a table I can still do a full text search.Whereas, in previous versions of SQL, if I'd disabled it at database level adding a full-text index would not result in the ability to full text search.Fri, 28 Oct 2011 03:52:56 GMTDugyChttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxGood question, however the answer is a bit pedantic, so I'm going to be a bit pedantic in my comment. Whilst you can't disable full text search at the database level, you can achieve this in effect by disabling it at the table level, so if you do it on all tables, it is removed, is it not?:-)Fri, 28 Oct 2011 03:38:05 GMTipounderhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxAlthough, 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.Ah well... got me :-PFri, 28 Oct 2011 02:57:53 GMTDugyChttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxThis is a good question, and I think the discussion to follow is going to be quite interesting.Fri, 28 Oct 2011 02:48:30 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxNice question, glad I received a point :)But you can disable or Re-enable a [b]Table[/b] for Full-Text Indexing :)[url=http://technet.microsoft.com/en-us/library/ms142536.aspx]http://technet.microsoft.com/en-us/library/ms142536.aspx[/url]Fri, 28 Oct 2011 02:44:03 GMTRhoxhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxThanks for the question.However, I'm curious about the discussion to follow, as I personally find the wording ambiguous ;-)In order to be able to carry out a (plain English) full text search, you have to set up a (MSDN speak) full-text catalog with at least one full-text index (see MSDN [url=http://msdn.microsoft.com/en-us/library/ms142497.aspx]Getting Started with Full-Text Search[/url]).In plain English: While any database created in SQL Server 2008 (and higher) is (MSDN speak) full-text enabled (please note: [b]no[/b] [i]search[/i]), use of this feature can only be made after performing certain steps. And if you drop the full-text index, no (plain English) full text search can be carried out (what I'd say qualifies as 'full text search is disabled').So thanks again for the question and pointing towards the interesting wording approach by MSDN. :cool:Fri, 28 Oct 2011 02:37:04 GMTmichael.kaufmannhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxGreat question, I didn't know this was the default.Learned something on a Friday :-DFri, 28 Oct 2011 00:03:03 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxGood question, never heard about this. Thanks.Thu, 27 Oct 2011 21:58:00 GMTmohammed moinudheenhttp://www.sqlservercentral.com/Forums/Topic1197318-2785-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Administration/76053/">SQL Server 2008 - Disabling Full Text Search</A>[/B]Thu, 27 Oct 2011 21:57:35 GMTNakul Vachhrajani