Post: Helpful Info on SQL Express 2005 when first using Full Text Search!

Hints And Tips research knowledge archive

Browse > Computers > Programming > Databases

Tip# 451

Sponsored Links

Subject:	Helpful Info on SQL Express 2005 when first using Full Text Search!
Updated:	Jan-3-2007
Rating:	Not Rated
By:	Rocky Moore - Member #: 461
Location:	Klamath Falls, Oregon USA
Website:	www.ReflectedThought.com
Category:	Computers > Programming > Databases

Rate This Tip (10=Great): 1 2 3 4 5 6 7 8 9 10

Recently, Microsoft added Full Text search capabilities to MS SQL Express 5000 in a packaged titled Advanced. It simply indexes one or more fields based on text words making it quick to find a record containing certain keywords.

While I have worked some with Full Text abilities in SQL Server 2005 Enterprise, I have not used them through the SQL Server Management Studio Express. It appears Full Text features were not originally supported and you need SQL SP2 to obtain any of the features.

Here is a good post on Full Text features in SQL Server 2005 Express by hand on:

http://www.wherecanibuyit.co.uk/ASP/full-text-search.html

[Submit DIGG for this tip]

<- Back

-----------
Note: Use the tips posted on this site at your own risk. The tips are posted by the public and as such may or may not be valid.

Categories

< Previous

Sponsor Sites To Visit

www.SaintsInLight.com

Thoughts on the Christian walk
along various Christian links.

CICK HERE

www.BringingInTheHarvest.com

Christian: The harvest is ripe and
the day is short, we need to bring in
the harvest while there is time!

CLICK HERE

RSS Feed

You can now get updates to the Recent Tips section by using RSS. The address is:

HintsAndTips.com/Rss.aspx

* Posting Tips *

To post a Tip, Recommendation or Tips Wanted, simply browse to the category you feel is a best fit for your post (click on the Recommention or Tips Wanted tab if fitting) and then click on "New Post" option.