SQL Server Properties (Server Settings Tab)
Use this tab to view or specify the following options.
Options
Default language for user
Specify the default language for server messages.
Allow modifications to be made directly to the system catalogs
Allow modifications to be made directly to the system catalogs.
Allow triggers to be fired which fire other triggers (nested triggers).
Allow nested triggers to be fired.
Use query governor to prevent queries exceeding specified cost
Select the cost query governor as a tool for preventing queries from exceeding the specified cost.
Mail login name
Specify the valid mail login name for the mail client.
When a two-digit year is entered, interpret as a year between
Specify how an instance of Microsoft® SQL Server™ interprets two-digit years. To change the time span, type the ending year. The default time span is 1950 to 2049. The beginning date is January 1, 1950, and the ending date is December 31, 2049. 99 is interpreted as 1999 and 01 is interpreted as 2001. The rule is that years less than or equal to the last two digits of the cutoff year are in the same century as that of the cutoff year. Years greater than the last two digits of the cutoff year are in the century previous to that of the cutoff year. Four-digit years are not affected by this option. If you want SQL Server to use the same two-digit cutoff year as the client, select 2030.
Configured values
View or change the configured values for the options on this tab. If you change these values, click Running values to see whether the changes have taken effect. If they have not, you must restart the instance of SQL Server for the changes to be implemented.
Running values
View the current running values for the options on this tab. These values are read-only.