O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using T-SQL to Set Database Options

If you prefer to use T-SQL, or if the option you need to set doesn’t appear in the Database Properties dialog, you can use the ALTER DATABASE command to set options. For example, the following command sets AUTO_UPDATE STATISTICS to OFF in the AdventureWorks2012 database:

ALTER DATABASE [AdventureWorks2012] SET AUTO_UPDATE_STATISTICS OFF WITH NO_WAIT

In earlier versions of SQL Server, you could also change some of the options by using the system stored procedure sp_dboption. The sp_dboption was removed in SQL Server 2012. This system procedure was an essential tool for DBA’s in the past. Make sure to update any scripts or other places that you may have use this procedure so that ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required