/*This will return the version on MSSQLServer:*/
SELECT SERVERPROPERTY('productversion')
/*This will return the service pack information of MSSQLServer:*/
SELECT SERVERPROPERTY('productlevel')
/*This will Full Text Search component is installed or not:*/
SELECT SERVERPROPERTY('IsFullTextInstalled')
/*This will show - is current database is full-text indexed:*/
select DatabaseProperty(db_name(), 'IsFulltextEnabled')
/*This will enable full-text indexing for the current database:*/
exec sp_fulltext_database 'enable'
/*This creates a catalog:*/
exec sp_fulltext_catalog 'catalogname', 'create'
/*This enables indexing of a table:*/
exec sp_fulltext_table 'tablename', 'create','catalogname', 'indexname'
/*This adds a column to an index:*/
exec sp_fulltext_column 'tablename', 'columnname', 'add'
/*This activates fulltext on a table:*/
exec sp_fulltext_table 'tablename', 'activate'
/*These two enable automatic filling of the full-text index when changes occur to a table:*/
exec sp_fulltext_table 'tablename','start_change_tracking'
exec sp_fulltext_table 'tablename','start_background_updateindex'