-- To Enable.
ALTER DATABASE Database_Name
SET AUTO_UPDATE_STATISTICS ON
-- To Disable.
ALTER DATABASE Database_Name
SET AUTO_UPDATE_STATISTICS OFF
asp.net,c#.net, MVC, WPF, WCF, JavaScript, JQuery, SQL Server, Interview Q&A
-- To Enable.
ALTER DATABASE Database_Name
SET AUTO_UPDATE_STATISTICS ON
-- To Disable.
ALTER DATABASE Database_Name
SET AUTO_UPDATE_STATISTICS OFF