SQL Full Text Search SBS 2008 SQL Server 2008

Posted on 2009-12-16
Last Modified: 2012-05-08
I just learned the hard way that you cannot install SQL Server 2008 on an SBS 2008 server the same way you do on a full blown W2008 server. I did wind up getting it to install by installling one component at a time and also installing the Management tools for SQL Server 2008 Express Edition. My question here is regarding Full Text Search. SQL is being installed simply for the accounting program. The accounting program does not need Full Text Search. Exactly what does Full Text search do and since the accounting program will not make use of it should I simply not install it?
Question by:rwheeler23
    1 Comment
    LVL 14

    Accepted Solution

    Full-text queries perform linguistic searches against text data in full-text indexes by operating on words and phrases based on rules of a particular language such as English or Japanese. Full-text queries can include simple words and phrases or multiple forms of a word or phrase.

    Because the accounting systems nature are numeric you may not need to take advantage of this component. SQL Server can make the normal searches on text.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    Title # Comments Views Activity
    SQL Query 2 44
    Help with SQL 9 61
    SQL Schedule Job 1 12
    Find data in sql table column which is not integer 5 19
    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now