Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

SQL Server 2008 - Disabling Full Text Search Expand / Collapse
Author
Message
Posted Friday, October 28, 2011 4:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:25 PM
Points: 1,253, Visits: 13,546
good question!!! thanks!


rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1197393
Posted Friday, October 28, 2011 4:32 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 6:49 AM
Points: 861, Visits: 793
Nice one, thanks

Iulian
Post #1197395
Posted Friday, October 28, 2011 5:35 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 1,625, Visits: 2,034
Not the first time using SSMS help has steered me in the wrong direction. I'm learning.

Thanks for the question.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1197411
Posted Friday, October 28, 2011 8:29 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 10:42 AM
Points: 20,460, Visits: 14,086
hmmm...interesting question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1197508
Posted Friday, October 28, 2011 8:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
good question - thanks!
Post #1197515
Posted Friday, October 28, 2011 12:54 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 4,244, Visits: 3,321
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.
Post #1197641
Posted Monday, October 31, 2011 5:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, Visits: 247
Good question and a lot of great discussions. Thanks for submitting.

http://brittcluff.blogspot.com/
Post #1197981
Posted Monday, October 31, 2011 5:56 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 10:36 AM
Points: 896, Visits: 1,479
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
Post #1197994
Posted Monday, October 31, 2011 9:42 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:46 AM
Points: 3,150, Visits: 1,900
Interesting question. I blew this one but learned something. Thanks!
Post #1198148
Posted Monday, October 31, 2011 7:31 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 5:10 PM
Points: 589, Visits: 2,436
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
Too much to learn in SQL... but very nice to always have something to learn

Thanks!
Post #1198411
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse