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. |