Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Microsoft SQL Server 2000 Best Practices Analyzer 1.0 Beta
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 11/20/2003 :  17:43:59  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Microsoft SQL Server Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices. These Best Practices typically relate to the usage and administration aspects of SQL Server databases and ensure that your SQL Servers are managed and operated well.

Article Link.

SQL Server MVP & SQLTeam MVY

United Kingdom
846 Posts

Posted - 11/25/2003 :  12:11:40  Show Profile  Visit jasper_smith's Homepage  Reply with Quote
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'
        SELECT * FROM dbo.bpa_job_bestpractices jbp WHERE

A newer build of BPA has been posted to the web removing the aformentioned rule. Uninstall of previous build is required.

Go to Top of Page

Starting Member

1 Posts

Posted - 12/03/2003 :  17:18:58  Show Profile  Reply with Quote
If my memory is correct you will need the .NET Framework 1.1 installed on your server in order to use this tool.
Go to Top of Page

SQL Server MVP & SQLTeam MVY

United Kingdom
846 Posts

Posted - 12/04/2003 :  07:42:45  Show Profile  Visit jasper_smith's Homepage  Reply with Quote
Not on your server(s), just where you install the tool, generally you would not install this on a server (especially as it is in beta)
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000