i can again/still/no longer manage full-text indexes on SQL Server. i'm logged on locally to my server, as an administrator. EM is set to poll the server. Has anyone written a gui to manage SQL Server free-text indexing?
-- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Ian Boyd" wrote in message news:uG7DGLVXHHA.4520@TK2MSFTNGP06.phx.gbl... >i can again/still/no longer manage full-text indexes on SQL Server. > > i'm logged on locally to my server, as an administrator. EM is set to poll > the server. > > > Has anyone written a gui to manage SQL Server free-text indexing? >
Have you tried this? It works for me every time. C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlftzwiz.exe -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Ian Boyd" wrote in message news:uG7DGLVXHHA.4520@TK2MSFTNGP06.phx.gbl... >i can again/still/no longer manage full-text indexes on SQL Server. > > i'm logged on locally to my server, as an administrator. EM is set to poll > the server. > > > Has anyone written a gui to manage SQL Server free-text indexing? >
> Have you tried this?> > C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlftzwiz.exe Do you know which tool is used to maintain a full-text catalog / enable disable table / start stop automatic-change tracking / start top incremental population / start stop full population / see what databases/tables/columns are being FT indexed / view/edit the work breaker set on a column / etc?
Under the covers some procs are used in SQL 2000, in SQL 2005 its moved into the engine. In SQL 2000 in some of the earlier versions you could use some of the com components to manage parts of it. Have a look at ssadmin.vbs in C:\Program Files\Common Files\System\MSSearch\Bin -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Ian Boyd" wrote in message news:ONMJiglYHHA.2320@TK2MSFTNGP03.phx.gbl... >> Have you tried this?> > >> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlftzwiz.exe > > Do you know which tool is used to maintain a full-text catalog / enable > disable table / start stop automatic-change tracking / start top > incremental population / start stop full population / see what > databases/tables/columns are being FT indexed / view/edit the work breaker > set on a column / etc? >
