Discussion Locked

SQL Server Full-Text Indexing

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to add a full text index to a table in Desktop SQL Server 2000. I right-click on the table, but the menu item "Full-Text Index Table" is grayed out. Any ideas?

3 replies

by maxwell edison

Greetings,

By default, SQL Server Setup doesn't install the Full-Text Search service. You can install it as part of a custom installation of SQL Server 7, or you can add it later by running SQL Server Setup again. You'll need about 25 MB of free disk space on the drive where you've installed Windows NT. In addition, you'll need an NTFS partition in which to store the Full-Text Catalogs. As shown in Figure A, you install the Full-Text Search service by checking its associated option in the Select Components dialog box.

Use the Select Components dialog box to install the Full-Text Search service on your server.

Cut and paste this link for full instructions and illustrations:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnntpro01/html/ntp0111.asp

REMOVE SPACES if they snuck into the pasted URL.

Maxwell

This discussion is closed to new replies.