CODEWITHSUNDEEP
sql-server
Brent Lamborn
Brent Lamborn

Reputation: 1390

SQL Server 2005 Full Text Search - Enabled but no name?

I'm working on a SQL Server 2005 -> 2008 upgrade. Full-text search seems to be a possible blocking point when doing an in-place upgrade. Among the possible problems are having a catalog named with more than 120 characters.

I ran this query on my 2005 instance to find 7 databases in the instance I want to upgrade that have full text enabled:

select * from sys.databases
where is_fulltext_enabled = 1
order by name

Then on each of the 7 db's, I ran this to try to determine the name of the catalogs:

select * from sysfulltextcatalogs

None of the 7 returned any records in the sysfulltextcatalogs table. My question is:

Is it possible to have full text search enabled, but have no actual catalog created?

Upvotes: 0

Views: 142

Answers (1)

Paul Hunt
Paul Hunt

Reputation: 3575

Yes it is absolutely possible to have full text enabled and no catalogs created. In fact in SQL 2008 all databases are always full-text enabled as per http://msdn.microsoft.com/en-us/library/ms403375(v=SQL.100).aspx

Upvotes: 1

Related Questions