Developer Docs - Developer Codex - SQL Database Recommended Settings

In order to complete this, all connections to [YOUR_DB_NAME] need to be closed.

Run the query ALTER DATABASE [YOUR_DB_NAME] SET READ_COMMITTED_SNAPSHOT OFF

or you can use SQL Server Management Studio to update your settings:

Setting Read Committed Snapshot On to FALSE in SSMS

For further technical reading, https://sqlperformance.com/2014/05/t-sql-queries/read-committed-snapshot-isolation.