无法启用在Azure上的SQL数据库V12全文搜索 [英] Cannot enable Full-Text search on Azure SQL Database V12

问题描述

我试图让我的Azure SQL数据库全文搜索。我升级我的数据库，以V12标准实例。升级已得到成功完成。我这样说是因为状态说在线门户网站上。然而，当我在下面执行此命令，

I'm trying to enable Full-Text search on my Azure SQL Database. I upgraded my DB to V12 Standard instance. The upgrade has got completed successfully. I say that because the Status says "Online" on the portal. However, when I execute this command below,

CREATE FULLTEXT CATALOG ftCatalog AS DEFAULT;

它抛出一个错误说，

it throws an error saying,

Msg 9972, Level 16, State 100, Line 2 
Database is not fully started up or it is not in an ONLINE state. Try the full-text DDL command again after database is started up and becomes ONLINE.

我下面这个博客<一href=\"http://azure.microsoft.com/blog/2015/04/30/full-text-search-is-now-available-for-$p$pview-in-azure-sql-database/\"相对=nofollow>帖子

有什么地方出错了？

推荐答案

执行如果万一你想避免MSFT通信的往返下面通过连接到数据库的两个语句，以及修复了这一点。

Executing the below two statements by connecting to the database as well fixes this if in case you want to avoid the round trip of communicating to MSFT.

 Alter database [dbname] set read_committed_snapshot off with rollback immediate
Alter database [dbname] set read_committed_snapshot on with rollback immediate

这篇关于无法启用在Azure上的SQL数据库V12全文搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！