Full text details using TSQL

-- catalogue details
SELECT name, path, is_default, is_accent_sensitivity_on
FROM sys.fulltext_catalogs

-- full text index details
SELECT object_name(object_id) table_name, change_tracking_state_desc
FROM sys.fulltext_indexes

-- full text index columns details
SELECT distinct ixc.object_id, object_name(ixc.object_id) tblname, col.name, ixc.*
FROM sys.fulltext_index_columns as ixc
INNER JOIN sys.columns as col ON ixc.object_id = col.object_id AND ixc.column_id = col.column_id
ORDER BY col.name

SQLDBTools - Tools

SQL Server 2005 database schema comparison

At last my search to find a good quality free database comparison tool is now over.

Worth a try: SQLDBTools - Tools

SQL Server 2005 Database comparision

SQLDBDiff V1.2.0 (Freeware)
http://www.sqldbtools.com/Downloads.aspx?ProductId=1

Best free database comparison tool.