Full-Text Index in Enterprise Manager

  • I've been trying to create a full-text index using Enterprise Manager. If I right-click on the table, "Full-Text Index Table" is grayed-out. If I right-click on Full-Text Catalogs, "New Full-Text Catalog" is grayed-out. If I try to start the Full-Text Indexing Wizard it tells me that the "Full-Text Server service needs to be running." The SQL database is on a remote server, and the host assures me that everything on their end is working properly. Does anybody know what I have to do??

  • In Enterprise Manager, Expand "Support Services". There you will find a way to turn on the Full-Text service.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • You mean right-click "Full-Text Search > Start" under "Support Services?" Tried that. It tells me that the "RPC server is unavailable." I checked with the host and they told me that Full-Text search IS running. I figure I must be getting that error because it's a shared server, therefore I don't have access to certain things.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply