098. SQL Server Script to Enable and disable Auto Update Statistics Asynchronously

-- 098. SQL Server Script to Enable and disable Auto Update Statistics Asynchronously

-- To Enable.
ALTER DATABASE Database_Name
SET AUTO_UPDATE_STATISTICS_ASYNC ON
 
-- To Disable. 
ALTER DATABASE Database_Name
SET AUTO_UPDATE_STATISTICS_ASYNC OFF