Microsoft® SQL Server® 2012 Bible

474

Part V: Enterprise Data Management

10 LegalCopyright NULL Microsoft Corp. All

rights reserved.

11 LegalTrademarks NULL Microsoft SQL Server is a

registered trademark of

Microsoft Corporation.

12 OriginalFilename NULL SQLSERVR.EXE

13 PrivateBuild NULL NULL

14 SpecialBuild 116588544 NULL

15 WindowsVersion 393281542 6.1 (7601)

16 ProcessorCount 1 1

17 ProcessorActiveMask 1 00000001

18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM

19 PhysicalMemory 2046 2046 (2145845248)

20 Product ID NULL NULL

The information returned by sp_configure is settable, but the information returned by xp_msver is not.

Confi guring the Database

The database-level options confi gure the current database’s behavior regarding ANSI com-

patibility and recovery.

Most database options can be set in Management Studio within the Database Properties

page, which you can fi nd by right-clicking a database in the console tree and choosing

Properties from the context menu. Figure 19-2 shows the Options tab.

The database confi guration options can be set using T-SQL ALTER DATABASE SET options.

The following example sets the AdventureWorks database to single user mode to obtain

exclusive access.

ALTER DATABASE AdventureWorks SET SINGLE_USER;

View database confi guration options using the sys.databases catalog view or the

DATABASEPROPERTYEX() function. The following example returns all the database proper-

ties of the AdventureWorks database:

SELECT * FROM sys.databases WHERE name = 'AdventureWorks';

Do not use the sp_dboption system stored procedure because this has been removed in SQL Server 2012.

c19.indd 474c19.indd 474 7/30/2012 5:42:47 PM7/30/2012 5:42:47 PM

http://www.it-ebooks.info