开发者

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

开发者 https://www.devze.com 2023-04-10 18:37 出处:网络
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 mor

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

0

精彩评论

暂无评论...
验证码 换一张
取 消