Query

Hi
Is there any T-SQL script/query to find out is full text search service
precent or not?
For example if i have SQL 2005 Express then no and yes if i have SQL 2005
Express Advanced?
Best regards
Mex
SELECT fulltextserviceproperty('IsFulltextInstalled')
returns 1 if it is installed 0 if it is not.
http://www.zetainteractive.com - Shift Happens!
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
"Meels Lilbok" <meelis.lilbok@.deltmar.ee> wrote in message
news:2514C014-0348-4B92-AA77-07A8B20F0BFD@.microsoft.com...
> Hi
> Is there any T-SQL script/query to find out is full text search service
> precent or not?
> For example if i have SQL 2005 Express then no and yes if i have SQL 2005
> Express Advanced?
>
> Best regards
> Mex
>