Microsoft® SQL Server® 2012 Bible

473

Chapter 19: Confi guring SQL Server

19

Result:

name minimum maximum config_value run_value

--------------------------- ----------- ----------- ------------

allow updates 0 1 0 0

backup compression default 0 1 0 0

clr enabled 0 1 0 0

cross db ownership chaining 0 1 0 0

default language 0 9999 0 0

FILESTREAM access level 0 2 2 2

max text repl size (B) -1 2147483647 65536 65536

nested triggers 0 1 1 1

remote access 0 1 1 1

remote admin connections 0 1 0 0

remote login timeout (s) 0 2147483647 20 20

remote proc trans 0 1 0 0

remote query timeout (s) 0 2147483647 600 600

server trigger recursion 0 1 1 1

show advanced options 0 1 0 0

user options 0 32767 0 0

You can always discover the minimum and maximum values for a particular confi guration option by running the sp_

configure command with the option, but without any value. For example, run:

EXEC sp_configure ‘remote login timeout’;

and you discover that the remote login timeout confi guration option can have any value in the range of 0 to

2,147,483,647.

The extended stored procedure, xp_msver, reports additional server and environment

properties:

EXEC xp_msver;

Result:

Index Name Internal_Value Character_Value

1 ProductName NULL Microsoft SQL Server

2 ProductVersion 655360 11.0.2100.6

3 Language 1033 English (United States)

4 Platform NULL NT INTEL X64

5 Comments NULL SQL

6 CompanyName NULL Microsoft Corporation

7 FileDescription NULL SQL Server Windows NT

8 FileVersion NULL 2011.0110.2100.060

((SQL11_RTM).120210-1917)

9 InternalName NULL SQLSERVR

c19.indd 473c19.indd 473 7/30/2012 5:42:46 PM7/30/2012 5:42:46 PM

http://www.it-ebooks.info