• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

SQL Full Text Search SBS 2008 SQL Server 2008

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?
0
rwheeler23
Asked:
rwheeler23
1 Solution
 
profyaCommented:
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.

http://msdn.microsoft.com/en-us/library/ms142547.aspx

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.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now