Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-20 : 17:43:59
|
| 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
846 Posts |
Posted - 2003-11-25 : 12:11:40
|
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 AllWe'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 WHEREbpa_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. |
 |
|
|
zzx375
Starting Member
1 Post |
Posted - 2003-12-03 : 17:18:58
|
| If my memory is correct you will need the .NET Framework 1.1 installed on your server in order to use this tool. |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-12-04 : 07:42:45
|
| 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) |
|
|
|
|
|
|
Article: Microsoft SQL Server 2000 Best Practices Analyzer 1.0 Beta