Microsoft SQL Server 2000 Best Practices Analyzer Beta Released
Microsoft recently released a beta of their SQL Server 2000 Best Practices Analyzer. This software scans SQL Server 2000 for compliance with over 70 Best Practices as identified by Microsoft. (12/8/2003)
This software is currently in beta. However it doesn't need to be installed on your production server. It's typically installed on an administrator workstation and then scans the target servers. It does require .NET 1.1 on the workstation. The best practices range from "Yukon" readiness to server configuration to T-SQL syntax. I strongly encourage you to give this tool a try.