O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, 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

Retrieving Option Information

You can retrieve database settings by using several different methods. You can use the Database Properties dialog in SSMS (as described in the preceding section) to display commonly accessed options. You can also use the DATABASEPROPERTYEX function or the sys.databases catalog view to display individual database options. As mentioned previously, sp_dboption was removed, so the DATABASEPROPERTYEX function is preferred. This function accepts input values for the database name and the option for which you want to retrieve the value. The following is an example of a SELECT statement you can use to retrieve the Auto Shrink option for the AdventureWorks2012 database:

SELECT DATABASEPROPERTYEX ...

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