Installing SQL Server Full Text Search

Full text search provides the ability to search documents and text within SQL Server. This video shows you how to install full text search and some of the caveats that go along with installation.

Robert C. Cain is a Microsoft MVP in SQL Development, and works as a Senior BI Architect for ComFrame. His main responsibility is the SQL Server Business Intelligence Data Warehouse for the NASA ARES project. He is also a contributing author to the book "SQL Server MVP Deep Dives". Prior to his current position, Robert spent five years working for a south eastern nuclear power company designing an...

Brent Templeton on 11/11/2008

Now that Full Text is turned on, how do we use? Could use an example.

Kris Robinett on 11/11/2008

Would not load.

Rubens on 11/11/2008

Although the video was informative, it probably would've made sense to check the Services first before running the SQL 2008 install.

Rubens on 11/11/2008

Although the video was informative, it probably would've made sense to check the Services first before running the SQL 2008 install.

Chris Rock on 11/11/2008

Brent, Click on the authors name above. This will take you to more videos while we continue to make the other videos available in a playlist.

borjonx on 11/11/2008

i really like the way the guy speaks. very clear and concise - and not fast.

82796FB536 on 11/11/2008

the name of the webcast can be better

Marcin Zawadzki on 11/12/2008

Only 50% content for me.

Munshi Verma on 11/12/2008

That's nice.

luther smith on 11/19/2008

Short and sweet!

John O'Sullivan on 11/29/2008

Excellent video

Geoff on 12/10/2008

Video was good, just didnt cover the situation Im faced with, as Full Text Search doesnt appear as a feature to install when I go to 2008 Setup Manager.

Vivek7dm on 12/18/2008

Got what is wanted

edidude2004 on 1/20/2009

Its an excellent video

Vinod Kushwaha on 2/4/2009

I didn;t installed FUll text feature on the first instance. The SQL 2008 samples wouldn't be installed because of this. I found it only here how to install FULL Text Search.

Ray Smith on 3/15/2009

Very Helpfull

Eugene on 4/22/2009

O man... you do not need to go all this way to check if FTS was installed: read BOL http://technet.microsoft.com/en-us/library/ms188418.aspx select FULLTEXTSERVICEPROPERTY('IsFulltextInstalled')

Ken McCrory on 5/1/2009

I think checking the service to see if it exists and is running would be the first step, not the second.

Tim Harms on 8/6/2009

Good information. Pretty standard video.

Benjamin Bielak on 8/13/2009

Exactly what I needed. Thanks

Francis Hanlon on 2/26/2010

I thought this was about installing Full Text Search not verifying we have already installed it.

Tony on 4/15/2010

Very informative. Thanks

Richard Douglas on 4/26/2010

Would it not have been best practice to check via the "SQL Server configuration manager" rather than the Services.msc?