Re: Problem with Best Practices Analyzer and set nocount on.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sethu Srinivasan [MSFT] (seths_at_online.microsoft.com)
Date: 01/18/05

Next message: xfile: "Any free tools for accessing and managing ISP SQL account?"
Previous message: Kalen Delaney: "Re: SQL Profiler Filters"
In reply to: Esio Nunes: "Problem with Best Practices Analyzer and set nocount on."
Messages sorted by: [ date ] [ thread ]

Date: Tue, 18 Jan 2005 15:40:00 -0800

Thanks Esio for reporting this issue.
We shall work on fixing this issue in future release of BPA

-- 
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Esio Nunes" <esio_nunes@hotmail.com> wrote in message 
news:%239d5MqL%23EHA.3988@TK2MSFTNGP11.phx.gbl...
> Hi.
>
> There is a bug with BPA.
> When you configure a server with sp_configure 'user options',512 or EM
> (default connection options) seting to NOCOUNT ON, BPA fails when reading
> the catalog.
>
> Esio
>
>

Next message: xfile: "Any free tools for accessing and managing ISP SQL account?"
Previous message: Kalen Delaney: "Re: SQL Profiler Filters"
In reply to: Esio Nunes: "Problem with Best Practices Analyzer and set nocount on."
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Best Practices Analyzer v1 now available
... I believe that for those of you that didn't go to TechEd, it may not be well known that v1 of BPA is now available. ... Christian Kleinerman ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
(microsoft.public.sqlserver.tools)
Re: BPA SELECT * Rule
... Seems that BPA is faster than me... ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > Christian Kleinerman ... >> Tibor Karaszi, SQL Server MVP ...
(microsoft.public.sqlserver.tools)