Misc Server Settings
The Misc Server Settings section of the Server Properties dialog allows you to configure the instance of Microsoft® SQL Server by setting miscellaneous server options in groups: General settings, Two-digit year support, Network settings.
Use the Default language for user drop-down list to select the default language for all newly created user logins.
Allow triggers to fire other triggers
Use this option to specify whether server-level triggers can be fired recursively.
Use query governor to prevent long-running queries
This option allows you to specify a limit on the time period in which a query can run. The query governor disallows execution of any query that has an estimated cost exceeding that value.
Two-digit year support
Interpret two-digit year as falling between 1950 and ...
Use this option to specify an integer from 1950 to 9999 that represents the cutoff year for interpreting two-digit years as four-digit years.
Use the Network packet size option to set the packet size (in bytes) used across the entire network.
Use the Remote login timeout option to specify the time interval (in seconds) to wait before returning from a failed attempt to log in to a remote server.