Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am in need to Install SQL server 2005 Express edition with Full Text Search capability. I don't know what to download and the order of installing the Database management system. Could someone provide me link to download the version with Full Text Search [as default 38Mb setup file does not have this feature].
Also step by step instruction to enable Full Text Search during the installation.

share|improve this question
add comment

1 Answer

up vote 5 down vote accepted

Full Text Search features are available in

Microsoft SQL Server 2005 Express Edition with Advanced Services
Microsoft® SQL Server® 2008 Express with Advanced Services

Installation and configuration are pretty simple, hope you have already installed express edition.

Give it a try!

UPDATE: 2011 - MARCH - 08

You will not be able manage Full Text Catalogs via SSMS.

SQL Server Management Studio Express

  • You cannot update the full-text catalog by using SSMSE. You can use sqlcmd utility or Windows Scheduler to update the full-text catalog.
share|improve this answer
    
Great thanks for the link appreciate it, Installation went breeze –  Deeptechtons Mar 4 '11 at 11:10
    
I am re-opening my question , Great that Full text service installs with the Installer file you specified but The management studio does not provide any of features to manage the Full Text catalogs. How do i get the management studio and not express editions –  Deeptechtons Mar 8 '11 at 6:15
    
@Deeptechtons - Please update your question or create a new question to ask this particular issue; meanwhile I'll check the issue with SSMS –  Coder Hawk Mar 8 '11 at 6:20
1  
Votes Up! sheesh doesnot allow me. But i think SQL Server Management Studio allows you to do that. Which btw comes packaged only along with Server 2005 Enterprise editions. Thanks helped me lot –  Deeptechtons Mar 8 '11 at 10:31
1  
@Deeptechtons - may be you can post your solution with SSMS 2005 Enterprise Edition as new answer to your own question. –  Coder Hawk Mar 8 '11 at 10:40
show 4 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.