Hints And Tips research knowledge archive
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 #: 1
Location: Klamath Falls, Oregon USA
Website: www.RockyMoore.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]


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

Sponsored Links
Categories
hints and tips gold divider
Sponsor Sites To Visit
The Awakening
Spirit-Filled Christianity is
more than filling a pew !

Not producing fruit?
Healing, where to turn?
Provision, where to turn?
Lost, where to turn?

It is time for --TheAwakening !
The Saints In Light
Christian Thoughts on
Various Topics - Check it Out!

Click Here
Silverlight City

Keep up with the latest in
Microsoft's Silverlight
Technology!

Click Here
Our Local Christians
Find other Christians
In your local area
Who share your beliefs!

Click Here
United Christian Voters
Tired of seeing your
Rights Vanish?
If all Christians would
Pull together, we can
bring Change Unite Now!

Click Here
Reflected Thought
Inventions ~ Ideas ~ Humor
Politics ~ Opinions ~ Thoughts
Software Development
Business And Stuff....

Click Here
HintsnTips.com
Articles on Various Topics!

Click Here
XML RSS News Feed For Recently Posted Hints And Tips  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.
(C) Copyright 1998-2009 All Rights Reserved By R & J Technologies - www.RJSoft.com