Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 916784 - Last Review: April 3, 2006 - Revision: 1.1
How to perform full-text search related tasks in SQL Server 2005 Express Edition with Advanced Services
Consider the following scenario. You install Microsoft SQL Server 2005 Express Edition with Advanced Services. You select
Full-Text Search during the installation. In this scenario, the following items that relate to full-text search are unavailable in the SQL Server Management Studio Express (SSMSE) user interface (UI):
- The Storage folder under a database folder
- The Full Text Index command in a table shortcut menu
This article describes how to perform full-text search related tasks in SQL Server 2005 Express Edition with Advanced Services.
SQL Server 2005 Express Edition with Advanced Services does not include SQL Server Agent functionality. Full-text search related tasks in the SSMSE UI require this functionality. However, you can perform Transact-SQL-based full-text search related tasks in the query editor in SSMSE.
The Template Explorer component that is included in SSMSE contains the following full-text search related templates:
- Create Full-text Catalog
- Create Full-text Index
- Start Full Population
- Stop Population
These templates help accelerate full-text search related task generation.
To access these full-text search related templates, follow these steps:
- Start SSMSE.
- Connect to the instance of SQL Server 2005 Express Edition.
- On the View menu, click Template Explorer.
- In Template Explorer, expand the Full-text folder. The full-text search related templates are in this folder.
To use the template, open a query editor in SSMSE. Then, drag the template from Template Explorer to the query editor.
For more information about the Transact-SQL statements that you can use to create and manage full-text catalogs and indexes, visit the following Microsoft Developer Network (MSDN) Web site:
APPLIES TO
- Microsoft SQL Server 2005 Express Edition
| kbhowto kbinfo kbsql2005fts kbexpertiseadvanced KB916784 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate