Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
This is supported for backward compatibility only. sp_fulltext_database doesn't disable the Full-Text Engine for a given database. All user-created databases in SQL Server are always enabled for full-text indexing.
Important
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Management Studio instead.
Transact-SQL syntax conventions
Syntax
sp_fulltext_database [ @action = ] 'action'
[ ; ]
Arguments
[ @action = ] 'action'
The action to be performed. @action is varchar(20), and can be one of these values.
| Value | Description |
|---|---|
| enable | Supported for backward compatibility only. It rebuilds all full-text catalogs of the database if the previous state of full-text is disabled. |
| disable | Supported for backward compatibility only. |
Return code values
0 (success) or 1 (failure).
Result set
None.
Remarks
In SQL Server 2008 (10.0.x) and later versions, full-text indexing can't be turned off. Disabling full-text indexing doesn't remove rows from sysfulltextcatalogs and doesn't indicate that full-text enabled tables are no longer marked for full-text indexing. All the full-text metadata definitions are still in the system tables.
Permissions
Only members of the sysadmin fixed server role and db_owner fixed database role can execute sp_fulltext_database.