Re: Best practice analyer

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Christian Kleinerman [MS] (ckleiner_at_online.microsoft.com)
Date: 09/08/04


Date: Tue, 7 Sep 2004 21:53:41 -0700

Some rules (e.g. syntax analysis, queries on the system catalog) will
succeed without sysadmin privileges, but some others (e.g. those that use
sp_configure) will require sysadmin privileges.

- Christian

-- 
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ann" <anonymous@discussions.microsoft.com> wrote in message
news:796e01c4950f$0b640990$a301280a@phx.gbl...
> what login permissions should I have to run best practice
> analyser tool? DO I have to be a sql server sysadmin?
>
> I use mixed mode.