Microsoft® SQL Server® 2012 Bible

500

Part V: Enterprise Data Management

Property Level* Graphic Control Code Option

Remote Login

Timeout

S Management

Studio

EXEC sp_configure 'remote login

timeout'

Remote Query

Timeout

S Management

Studio

EXEC sp_configure 'remote query

timeout'

Enforce DTC S Management

Studio

EXEC sp_configure 'remote proc

trans'

Network

Packet Size

S Management

Studio

EXEC sp_configure 'network

packet size'

* The confi guration level refers to server, database, or connection.

The Server Properties Connections tab (refer to Figure 19-9) sets connection-level proper-

ties, including defaults, number of connections permitted, and timeout settings.

FIGURE 19-9

Connections tab of Management Studio’s SQL Server Properties dialog.

TABLE 19-5 (continued)

c19.indd 500c19.indd 500 7/30/2012 5:43:01 PM7/30/2012 5:43:01 PM

http://www.it-ebooks.info