SYMPTOMS
Consider the following scenario. In Microsoft SQL Server 2005, you restore a database from a
backup. Then, you try to open a full-text catalog by using SQL Server Management
Studio. In this scenario, you may receive the following error message:
Property IsAccentSensitive is not available for
FullTextCatalog '[CatalogName]'. This property may
not exist for this object, or may not be retrievable due to insufficient access
rights. (Microsoft.SqlServer.Smo)
Additionally, when you try to query
the information about the
AccentSensitivity property of the full-text catalog by using the FULLTEXTCATALOGPROPERTY Transact-SQL function, you receive a null value. For example, you use a Transact-SQL statement that is similar to the following Transact-SQL statement to query the information about the
AccentSensitivity property.
select FULLTEXTCATALOGPROPERTY('<CatalogName>','AccentSensitivity')When you use this statement, you receive a null value. However, when you query the information about the
AccentSensitivity property directly from the full-text catalog view, SQL Server returns the correct information. For example, you can use the following
Transact-SQL statement to query the information.
select * from sys.fulltext_catalogs
This problem may occur when the following conditions are
true:
- You back up a database and then delete the
database.
- The database has a full-text catalog.
- Before you restore the database, you create one or
more databases. Therefore, the previous database ID is used by the newly created
databases.