2012年3月19日星期一

Full Text Indexing Option Disabled

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" <admin@.SWIFTPA.NET> 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" <admin@.SWIFTPA.NET> 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" <ian.msnews010@.avatopia.com> wrote in message
news:ONMJiglYHHA.2320@.TK2MSFTNGP03.phx.gbl...
>
> 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?
>

没有评论:

发表评论