enable async database init

Summary information

Default value

0 (off)

Valid values

0 (off), 1 (on)

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration groups

SQL Server Administration

enable async database init ensures that all create database and alter database commands initialize databases asynchronously by default.