Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot enable Full-Text search on Azure SQL Database 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.

I am following this blog post

What could be wrong?

like image 875
Imaya Kumar Avatar asked Apr 15 '26 22:04

Imaya Kumar


1 Answers

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
like image 129
Satya_MSFT Avatar answered Apr 18 '26 12:04

Satya_MSFT



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!