Server Error Messages 10400 - 10499


 additional network memory allocates additional memory for clients which request packet sizes that are larger than the default packet size for the server.
lock address spinlock ratio specifies the number of address lock buckets in the address locks hash table which are protected by each spinlock (buckets per spinlock). 
 allow nested triggers is a toggle that controls the use of nested triggers. When the value is set to 1, data modifications made by triggers can fire other triggers.
 allow remote access determines whether users from remote servers can access this SQL Server. The default is 1, to allow SQL Server to communicate with Backup Server.
 allow sql server async i/o is a toggle that enables SQL Server to run with asynchronous disk I/O.
 allow updates to system tables allows system tables to be updated directly. The default is 0 (off).
 audit queue size determines the number of audit records that the audit queue can hold. The default is 100.
 configuration file specifies the location of the configuration file you want to use.
 cpu accounting flush interval specifies how many machine clock ticks to accumulate before adding cpu usage data to syslogins for use in chargeback accounting statistics.
 cpu grace time specifies the maximum amount of time (in milliseconds) a user process can run without yielding the CPU before SQL Server infects it.
 deadlock checking period specifies the minimum amount of time (in milliseconds) a process must wait for a lock before SQL Server initiates a deadlock check.
 deadlock retries specifies the number of times a transaction will retry to acquire a lock after it has become a deadlock victim.
 default character set id is the number of the default character set used by the server.
 default database size sets the default number of megabytes allocated to each new user database. The default run value is 2 (megabytes)
 default fill factor percent sets how full SQL Server makes each page when creating a new index on existing data (unless user gives other value in create index statement).
 default language id is the number of the language that is used to display system messages unless a user has chosen another language from those available on the server.
 default network packet size sets the default size of network packets for all users on SQL Server.
 default sortorder id is the number of the current default sortorder on SQL Server. Do not change this parameter. See the System Administration Guide for more information.
 disk i/o structures specifies the initial number of disk I/O control blocks SQL Server allocates on startup.
 event buffers per engine specifies the number of events per SQL Server engine that can be simultaneously monitored. Events are used for observing SQL Server performance.
 executable code size reports the size of the SQL Server executable.
 freelock transfer block size specifies the number of locks moved between the engine freelock cache and the global freelock list.
 housekeeper free write percent sets the maximum percentage that database writes can increase because of free writes started by the housekeeper process.
 i/o accounting flush interval specifies how many disk I/Os to accumulate before flushing the data to syslogins for use in chargeback accounting.
 i/o polling process count specifies the number of tasks the scheduler will run before checking for disk and/or network I/O completions.
 identity burning set factor sets the percentage of potential IDENTITY column values made available in each block.
 identity grab size allows each SQL Server process to reserve a block of IDENTITY column values for inserts into tables that have an IDENTITY column.
page lock promotion HWM sets the maximum number of page locks allowed before SQL Server escalates to a table lock. The default value is 200. 
page lock promotion LWM sets the minimum number of page locks allowed before SQL Server escalates to a table lock. The default value is 200. 
page lock promotion PCT sets the percentage of page locks allowed before SQL Server escalates to a table lock. The default value is 100. 
 lock shared memory disallows swapping of SQL Server pages to disk, and allowing the operating system kernel to avoid the server's internal page locking code.
 max async i/o's per engine specifies the maximum number of asynchronous disk I/O requests that can be outstanding for a single engine at one time.
 max async i/o's per server specifies the maximum number of asynchronous disk I/O requests that can be outstanding for SQL Server at one time.
 max engine freelocks specifies the maximum number of locks available in an engine freelock cache.
 max network packet size sets the maximum network packet size that a client program can request.
 max number of network listeners specifies the maximum number of network listeners that can be open at one time.
 max online engines controls the number of engines in a symmetric multiprocessor environment.
 memory alignment boundary determines on which boundary buffer caches are aligned.
 min online engines is not currently used.
 number of alarms specifies the number of alarms allocated by SQL Server. Alarms are used with the Transact-SQL waitfor command.
 number of devices controls the number of database devices  SQL Server can use. It does not include devices used for database dumps.
 number of extent i/o buffers allocates the specified number of extents (8 data pages) for use by create index. Do not set this value to more than 100.
 number of index trips specifies the number of times an aged index page recycles itself onto the MRU chain.
 number of languages in cache is the maximum number of languages that can simultaneously be held in the language cache. The default is 3.
 number of locks sets the number of available locks. The default run value is 5000.
 number of mailboxes sets the number of mailbox structures SQL Server allocates on start-up. Mailboxes are use for process-to-process communication and synchronization.
 number of messages specifies the number of message structures allocated by SQL Server at start-up time. Messages are used in conjunction with mailboxes for process-to-process communication and synchronization.
 number of oam trips specifies the number of times an aged OAM page recycles itself onto the MRU chain.
 number of open databases sets the maximum number of databases that can be open at one time on SQL Server. The default run value is 12.
 number of open objects sets the maximum number of database objects that can be open at one time on SQL Server. The default run value is 500.
 number of preallocated extents specifies the number of extent structures allocated in a single trip to the page manager.
 number of remote connections controls the limit on active connections initiated to and from this SQL Server. The default is 20.
 number of remote logins controls the number of active user connections from this SQL Server to remote servers. The default is 20.
 number of remote sites controls the number of simultaneous remote sites that can access this SQL Server. The default is 10.
 number of sort buffers specifies the number of buffers used to hold pages read from input tables.
 number of user connections sets the maximum number of user connections that can be connected to SQL Server at one time.
 page lock spinlock ratio specifies the ratio of spinlocks protecting the internal page locks hash table.
 page utilization percent controls when SQL Server performs an OAM (Object Allocation Map) scan to find unused pages. The default run value is 95.
 partition groups sets how many partition groups to allocate for the server. Partition groups are used by SQL Server to control access to individual partitions of tables.
 partition spinlock ratio sets the number of partition caches each spinlock protects. These spinlocks keep processes from using partition caches used by other processes.
 permission cache entries determines the number of cache protectors per task.
 print deadlock information enables printing of deadlock information to the error log.
 print recovery information determines what information SQL Server displays on the console during recovery.
 procedure cache percent specifies the amount of memory allocated to the procedure cache after SQL Server's memory needs are met. The default run value is 20.
 recovery interval in minutes sets the maximum time per database that SQL Server uses to complete its recovery procedures in case of a system failure.
 remote server pre-read packets controls the number of packets that a site handler will pre-read in connections with remote servers. The default is 3.
 runnable process search count specifies the number of times an engine will loop looking for a runnable task before relinquishing the CPU.
 sort page count specifies the maximum amount of memory a sort operation can use.
 sql server clock tick length specifies the duration of the server's clock tick, in microseconds.
 stack guard size specifies the size of the stack guard area.
 stack size sets the size of SQL Server's execution stack.
 systemwide password expiration is the number of days that passwords remain in effect after they are changed. The default is 0 (passwords do not expire).
lock table spinlock ratio specifies the number of table lock buckets in the table lock hash table which are protected by each spinlock (buckets per spinlock). 
 tape retention in days sets the number of days you want to retain each tape after it has been used for a database or transaction log dump.
 tcp no delay disables TCP packet batching.
 time slice sets the number of milliseconds that SQL Server's scheduler allows a user process to run. The default run value is 100 milliseconds.
 total data cache size represents the amount of memory currently available for use as a data cache. It is a calculated value that is not directly user-configurable.
The run value of ’total logical memory’ indicates the size of memory required to satisfy the current configuration.
 upgrade version is changed by the upgrade program provided with new releases.
 user log cache size specifies the size (in bytes) for each user's log cache.
 user log cache spinlock ratio specifies the number of user log caches per user log cache spinlock.
 shared memory starting address determines the virtual address at which SQL Server starts its shared memory region. Most users do not need to modify this.
 size of auto identity column sets the precision of IDENTITY columns automatically created with the sp_dboption `auto identity' option.
 os file descriptors is a read-only parameter that indicates how many file descriptors have been allocated to SQL Server. It is not user-configurable.
Allow-limits allows the Resource Governor feature to be used by SAs. Default is 0 (off); static. 
number of auxiliary scan descriptors sets the maximum number of auxiliary scan descriptors that can be shared among all connections at one time. The default run value is 2 00. 
number of open indexes sets the maximum number of indexes that can be open at one time on SQL Server. The default value is 500. 
open object spinlock ratio specifies the number of open objects protected by one spinlock. The default value is 100. 
open index hash spinlock ratio specifies the number of internal hash tables for open indexes protected by one spinlock. The default value is 100. 
open index spinlock ratio specifies the number of open indexes protected by one spinlock. The default value is 100. 
enable cis specifies whether Component Integration Services is loaded when the server is started. The default is 0 (do not load).
cis connect timeout specifies the number of seconds to wait for a connect request to a remote server to complete.
cis bulk insert batch size specifies the number of rows in a bulk copy batch when performing a SELECT INTO operation.
max cis remote connections specifies the maximum number of connections to remote servers that can be active at one time.
max cis remote servers specifies the maximum number of remote servers that can be accessed at one time.
cis packet size specifies the maximum size of a network packet.
cis cursor rows specifies the maximum number of rows that will be returned in response to a single fetch operation.
CIS idle timeout specifies the number of seconds to wait before terminating an idle connection with a remote server.

Number	Severity	Text and Explanation
10401	10	additional network memory allocates additional memory for clients which request packet sizes that are larger than the default packet size for the server. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10402	10	lock address spinlock ratio specifies the number of address lock buckets in the address locks hash table which are protected by each spinlock (buckets per spinlock). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10403	10	allow nested triggers is a toggle that controls the use of nested triggers. When the value is set to 1, data modifications made by triggers can fire other triggers. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10404	10	allow remote access determines whether users from remote servers can access this SQL Server. The default is 1, to allow SQL Server to communicate with Backup Server. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10405	10	allow sql server async i/o is a toggle that enables SQL Server to run with asynchronous disk I/O. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10406	10	allow updates to system tables allows system tables to be updated directly. The default is 0 (off). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10407	10	audit queue size determines the number of audit records that the audit queue can hold. The default is 100. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10408	10	configuration file specifies the location of the configuration file you want to use. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10409	10	cpu accounting flush interval specifies how many machine clock ticks to accumulate before adding cpu usage data to syslogins for use in chargeback accounting statistics. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10410	10	cpu grace time specifies the maximum amount of time (in milliseconds) a user process can run without yielding the CPU before SQL Server infects it. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10411	10	deadlock checking period specifies the minimum amount of time (in milliseconds) a process must wait for a lock before SQL Server initiates a deadlock check. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10412	10	deadlock retries specifies the number of times a transaction will retry to acquire a lock after it has become a deadlock victim. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10413	10	default character set id is the number of the default character set used by the server. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10414	10	default database size sets the default number of megabytes allocated to each new user database. The default run value is 2 (megabytes) Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10415	10	default fill factor percent sets how full SQL Server makes each page when creating a new index on existing data (unless user gives other value in create index statement). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10416	10	default language id is the number of the language that is used to display system messages unless a user has chosen another language from those available on the server. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10417	10	default network packet size sets the default size of network packets for all users on SQL Server. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10418	10	default sortorder id is the number of the current default sortorder on SQL Server. Do not change this parameter. See the System Administration Guide for more information. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10419	10	disk i/o structures specifies the initial number of disk I/O control blocks SQL Server allocates on startup. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10420	10	event buffers per engine specifies the number of events per SQL Server engine that can be simultaneously monitored. Events are used for observing SQL Server performance. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10421	10	executable code size reports the size of the SQL Server executable. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10422	10	freelock transfer block size specifies the number of locks moved between the engine freelock cache and the global freelock list. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10423	10	housekeeper free write percent sets the maximum percentage that database writes can increase because of free writes started by the housekeeper process. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10424	10	i/o accounting flush interval specifies how many disk I/Os to accumulate before flushing the data to syslogins for use in chargeback accounting. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10425	10	i/o polling process count specifies the number of tasks the scheduler will run before checking for disk and/or network I/O completions. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10426	10	identity burning set factor sets the percentage of potential IDENTITY column values made available in each block. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10427	10	identity grab size allows each SQL Server process to reserve a block of IDENTITY column values for inserts into tables that have an IDENTITY column. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10428	10	page lock promotion HWM sets the maximum number of page locks allowed before SQL Server escalates to a table lock. The default value is 200. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10429	10	page lock promotion LWM sets the minimum number of page locks allowed before SQL Server escalates to a table lock. The default value is 200. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10430	10	page lock promotion PCT sets the percentage of page locks allowed before SQL Server escalates to a table lock. The default value is 100. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10431	10	lock shared memory disallows swapping of SQL Server pages to disk, and allowing the operating system kernel to avoid the server's internal page locking code. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10432	10	max async i/o's per engine specifies the maximum number of asynchronous disk I/O requests that can be outstanding for a single engine at one time. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10433	10	max async i/o's per server specifies the maximum number of asynchronous disk I/O requests that can be outstanding for SQL Server at one time. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10434	10	max engine freelocks specifies the maximum number of locks available in an engine freelock cache. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10435	10	max network packet size sets the maximum network packet size that a client program can request. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10436	10	max number of network listeners specifies the maximum number of network listeners that can be open at one time. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10437	10	max online engines controls the number of engines in a symmetric multiprocessor environment. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10438	10	memory alignment boundary determines on which boundary buffer caches are aligned. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10439	10	min online engines is not currently used. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10440	10	number of alarms specifies the number of alarms allocated by SQL Server. Alarms are used with the Transact-SQL waitfor command. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10441	10	number of devices controls the number of database devices SQL Server can use. It does not include devices used for database dumps. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10442	10	number of extent i/o buffers allocates the specified number of extents (8 data pages) for use by create index. Do not set this value to more than 100. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10443	10	number of index trips specifies the number of times an aged index page recycles itself onto the MRU chain. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10444	10	number of languages in cache is the maximum number of languages that can simultaneously be held in the language cache. The default is 3. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10445	10	number of locks sets the number of available locks. The default run value is 5000. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10446	10	number of mailboxes sets the number of mailbox structures SQL Server allocates on start-up. Mailboxes are use for process-to-process communication and synchronization. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10447	10	number of messages specifies the number of message structures allocated by SQL Server at start-up time. Messages are used in conjunction with mailboxes for process-to-process communication and synchronization. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10448	10	number of oam trips specifies the number of times an aged OAM page recycles itself onto the MRU chain. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10449	10	number of open databases sets the maximum number of databases that can be open at one time on SQL Server. The default run value is 12. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10450	10	number of open objects sets the maximum number of database objects that can be open at one time on SQL Server. The default run value is 500. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10451	10	number of preallocated extents specifies the number of extent structures allocated in a single trip to the page manager. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10452	10	number of remote connections controls the limit on active connections initiated to and from this SQL Server. The default is 20. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10453	10	number of remote logins controls the number of active user connections from this SQL Server to remote servers. The default is 20. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10454	10	number of remote sites controls the number of simultaneous remote sites that can access this SQL Server. The default is 10. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10455	10	number of sort buffers specifies the number of buffers used to hold pages read from input tables. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10456	10	number of user connections sets the maximum number of user connections that can be connected to SQL Server at one time. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10457	10	page lock spinlock ratio specifies the ratio of spinlocks protecting the internal page locks hash table. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10458	10	page utilization percent controls when SQL Server performs an OAM (Object Allocation Map) scan to find unused pages. The default run value is 95. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10459	10	partition groups sets how many partition groups to allocate for the server. Partition groups are used by SQL Server to control access to individual partitions of tables. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10460	10	partition spinlock ratio sets the number of partition caches each spinlock protects. These spinlocks keep processes from using partition caches used by other processes. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10461	10	permission cache entries determines the number of cache protectors per task. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10462	10	print deadlock information enables printing of deadlock information to the error log. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10463	10	print recovery information determines what information SQL Server displays on the console during recovery. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10464	10	procedure cache percent specifies the amount of memory allocated to the procedure cache after SQL Server's memory needs are met. The default run value is 20. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10465	10	recovery interval in minutes sets the maximum time per database that SQL Server uses to complete its recovery procedures in case of a system failure. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10466	10	remote server pre-read packets controls the number of packets that a site handler will pre-read in connections with remote servers. The default is 3. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10467	10	runnable process search count specifies the number of times an engine will loop looking for a runnable task before relinquishing the CPU. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10468	10	sort page count specifies the maximum amount of memory a sort operation can use. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10469	10	sql server clock tick length specifies the duration of the server's clock tick, in microseconds. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10470	10	stack guard size specifies the size of the stack guard area. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10471	10	stack size sets the size of SQL Server's execution stack. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10472	10	systemwide password expiration is the number of days that passwords remain in effect after they are changed. The default is 0 (passwords do not expire). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10473	10	lock table spinlock ratio specifies the number of table lock buckets in the table lock hash table which are protected by each spinlock (buckets per spinlock). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10474	10	tape retention in days sets the number of days you want to retain each tape after it has been used for a database or transaction log dump. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10475	10	tcp no delay disables TCP packet batching. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10476	10	time slice sets the number of milliseconds that SQL Server's scheduler allows a user process to run. The default run value is 100 milliseconds. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10477	10	total data cache size represents the amount of memory currently available for use as a data cache. It is a calculated value that is not directly user-configurable. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10478	10	The run value of ’total logical memory’ indicates the size of memory required to satisfy the current configuration. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10479	10	upgrade version is changed by the upgrade program provided with new releases. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10480	10	user log cache size specifies the size (in bytes) for each user's log cache. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10481	10	user log cache spinlock ratio specifies the number of user log caches per user log cache spinlock. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10482	10	shared memory starting address determines the virtual address at which SQL Server starts its shared memory region. Most users do not need to modify this. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10483	10	size of auto identity column sets the precision of IDENTITY columns automatically created with the sp_dboption `auto identity' option. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10485	10	os file descriptors is a read-only parameter that indicates how many file descriptors have been allocated to SQL Server. It is not user-configurable. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10486	10	Allow-limits allows the Resource Governor feature to be used by SAs. Default is 0 (off); static. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10487	10	number of auxiliary scan descriptors sets the maximum number of auxiliary scan descriptors that can be shared among all connections at one time. The default run value is 2 00. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10488	10	number of open indexes sets the maximum number of indexes that can be open at one time on SQL Server. The default value is 500. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10489	10	open object spinlock ratio specifies the number of open objects protected by one spinlock. The default value is 100. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10490	10	open index hash spinlock ratio specifies the number of internal hash tables for open indexes protected by one spinlock. The default value is 100. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10491	10	open index spinlock ratio specifies the number of open indexes protected by one spinlock. The default value is 100. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10492	10	enable cis specifies whether Component Integration Services is loaded when the server is started. The default is 0 (do not load). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10493	10	cis connect timeout specifies the number of seconds to wait for a connect request to a remote server to complete. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10494	10	cis bulk insert batch size specifies the number of rows in a bulk copy batch when performing a SELECT INTO operation. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10495	10	max cis remote connections specifies the maximum number of connections to remote servers that can be active at one time. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10496	10	max cis remote servers specifies the maximum number of remote servers that can be accessed at one time. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10497	10	cis packet size specifies the maximum size of a network packet. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10498	10	cis cursor rows specifies the maximum number of rows that will be returned in response to a single fetch operation. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10499	10	CIS idle timeout specifies the number of seconds to wait before terminating an idle connection with a remote server. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.