Configuration Options (Level 2)

Configuration Options (Level 2)

Administrative scripts may have used these configuration options. For more information about configuration options, see sp_configure and Setting Configuration Options.

SQL Server 6.x SQL Server 2000
open objects set the maximum number of database objects that can be open at one time on SQL Server. Now an advanced option. Default value of 0 indicates automatic growth.

Expect different results as compared to earlier versions of SQL Server. Remove all references to open objects. For more information, see open objects Option.

user connections set the maximum allowed number of simultaneous connections to SQL Server. Now an advanced option. Default value of 0 indicates automatic growth.

Expect different results as compared to earlier versions of SQL Server. Remove all references to user connections Option.


Show: