Obsolete Configuration Options
Some of the configuration options available in SQL Server 7.0 are obsolete in SQL Server 2000. Some options, such as “time slice,” were just introduced in SQL Server 7.0 and then immediately became obsolete.
The following parameters are obsolete in SQL Server 2000:
| Obsoleted Configuration Options | |
|---|---|
| default sortorder id | resource timeout |
| extended memory size | spin counter |
| language in cache | time slice |
| language neutral full-text | unicode comparison style |
| max async IO | unicode locale id |
One of the all-time favorite options in SQL Server 7.0 was max async IO. The reason that option became obsolete is because it has been completely automated with SQL Server 2000. Previously, max async IO was used to specify the number of simultaneous ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
