<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Nakul Vachhrajani
»
SQL Server 2008 - Disabling Full Text Search
22 posts, Page 1 of 3
1
2
3
»
»»
SQL Server 2008 - Disabling Full Text Search
Rate Topic
Display Mode
Topic Options
Author
Message
Nakul Vachhrajani
Nakul Vachhrajani
Posted Thursday, October 27, 2011 9:57 PM
Ten Centuries
Group: General Forum Members
Last Login: Monday, June 10, 2013 6:56 AM
Points: 1,282,
Visits: 1,613
Comments posted to this topic are about the item
SQL Server 2008 - Disabling Full Text Search
Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.
Follow me on
Twitter:
@nakulv_sql
Google Plus:
+Nakul
Post #1197318
mohammed moinudheen
mohammed moinudheen
Posted Thursday, October 27, 2011 9:58 PM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 10:29 PM
Points: 2,178,
Visits: 3,599
Good question, never heard about this. Thanks.
Mohammed Moinudheen
Post #1197319
Koen Verbeeck
Koen Verbeeck
Posted Friday, October 28, 2011 12:03 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 6:30 AM
Points: 9,410,
Visits: 6,495
Great question, I didn't know this was the default.
Learned something on a Friday
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1197323
michael.kaufmann
michael.kaufmann
Posted Friday, October 28, 2011 2:37 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, May 28, 2013 1:34 AM
Points: 1,263,
Visits: 1,080
Thanks 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
Getting Started with Full-Text Search
).
In plain English: While any database created in SQL Server 2008 (and higher) is (MSDN speak) full-text enabled (please note:
no
search
), 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.
Post #1197361
Rhox
Rhox
Posted Friday, October 28, 2011 2:44 AM
Old Hand
Group: General Forum Members
Last Login: Monday, June 03, 2013 6:06 AM
Points: 388,
Visits: 296
Nice question, glad I received a point :)
But you can disable or Re-enable a
Table
for Full-Text Indexing :)
http://technet.microsoft.com/en-us/library/ms142536.aspx
Post #1197363
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Friday, October 28, 2011 2:48 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 3:51 AM
Points: 3,163,
Visits: 4,342
This is a good question, and I think the discussion to follow is going to be quite interesting.
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1197367
DugyC
DugyC
Posted Friday, October 28, 2011 2:57 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 1,182,
Visits: 745
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.
Ah well... got me
_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1197369
ipounder
ipounder
Posted Friday, October 28, 2011 3:38 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 3:53 AM
Points: 1,051,
Visits: 125
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?
Post #1197378
DugyC
DugyC
Posted Friday, October 28, 2011 3:52 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 1,182,
Visits: 745
ipounder (10/28/2011)
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?
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.
_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1197381
call.copse
call.copse
Posted Friday, October 28, 2011 4:10 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 4:01 AM
Points: 1,113,
Visits: 716
Wot DugyC sed. Fortunately I overrode my immediate impulse to get this one right!
Post #1197386
« Prev Topic
|
Next Topic »
22 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
