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 w开发者_StackOverflow中文版ant 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?
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
精彩评论