SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

AskSQLTeam
Ask SQLTeam Question

USA
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.

jasper_smith
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'
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.

Go to Top of Page

zzx375
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

jasper_smith
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  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000