I have instaled SQL server 2008 R2 and when I run this SQL in SQL server management studio:

SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')

I get 0

But If I run this:

SELECT * FROM sys.fulltext_catalogs

I get one row. I want to know If fulltext search is installed on my sql server or do I need to reinstall SQL server with advance options.

Please suggest.

Edit
Report