Set the open objects Option to 0 for SQL Server 2000

This rule checks the open objects server option for a nonzero setting. Using a nonzero value can lead to errors when you are using SQL Server 2000. This value should not be changed from the default value of 0 unless you are working with Microsoft Customer Support Services (CSS) on a workaround to a known problem.

Best Practices Recommendations

For instances of SQL Server 2000, set the open objects option to 0. This enables SQL Server to dynamically increase or decrease the total number of objects that can be open at the same time and obtain the best overall performance from the server.

For More Information

open objects Option