var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Full-text indexing installed but not available
Having problems getting FTS running.
SELECT fulltextserviceproperty('IsFulltextInstalled') returns 1, indicating it's installed, but all the FTS options are grayed out in Enterprise Manager.
If I try sp_fulltext_database 'enable', I get the following:
Server: Msg 7619, Level 16, State 2, Procedure sp_fulltext_database, Line 46
The device is not ready.
Here is the output of my @@VERSION:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
If it's relevant, I connect to the database in EM or QA using Windows authentication & a network machine name.
I'd be *very* grateful to anyone who can help. That error message doesn't turn up in Google even once as far as I can see.