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.

1 Answer 1


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.
  • Great thanks for the link appreciate it, Installation went breeze Mar 4, 2011 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 Mar 8, 2011 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 Mar 8, 2011 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 Mar 8, 2011 at 10:31
  • 1
    @Deeptechtons - may be you can post your solution with SSMS 2005 Enterprise Edition as new answer to your own question. Mar 8, 2011 at 10:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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