Please note the below if you have already installed this (prior to 24/11). You will need to download the beta refresh from the same link (the old version binaries are version 1.0.17 and the new ones are 1.0.20)
Hi All
We've identified an undesired potential side effect caused by one of the checks performed by the Best Practices Analyzer Beta Tool (BPA) released on 11/12.
It is recommended to not use the "Check Downlevel Clients" rule (under "Deprecation" category). Errors may occur on other connections on the server being scanned only while the rule is running.
To disable this rule from BPA and avoid unintentional execution you can run the following statements against the repository database:
DELETE FROM dbo.bpa_bestpractices WHERE bestpractice_id='DOWNLEVELCLIENTS'
DELETE FROM dbo.bpa_jobs WHERE NOT EXISTS (
SELECT * FROM dbo.bpa_job_bestpractices jbp WHERE
bpa_jobs.job_name=jbp.job_name)
A newer build of BPA has been posted to the web removing the aformentioned rule. Uninstall of previous build is required.
Article: Microsoft SQL Server 2000 Best Practices Analyzer 1.0 Beta
Posted - 11/20/2003 : 17:43:59
