Re: Viewing the Error Log through Enterprise Manager.

From: Ray (ray.x.bekker@gsk.com)
Date: 11/25/02 

From: "Ray" <ray.x.bekker@gsk.com>
Date: Mon, 25 Nov 2002 06:38:18 -0800

Hi Jasper,

Thanks for the reply. My user is actually part of the
SecurityAdmin - and ProcessAdmin. When this users opens
the EM MMC he cannot see the 'SQL Server Logs' item in the
tree, it's just not available. I have the same problem
with the 'Current Activity' item. He needs to see both,
any advice?

The use can run sp_readerrorlog through QA but I would
like this option through EM in a GUI.

Ray
>-----Original Message-----
>Members of the SecurityAdmin server role can also
>view the log - you don't need to be sysadmin.
>The only other way (unsupported/not recommended)
>would be to alter sp_readerrorlog to comment out the
>permissions check or modify it to perhaps check for
>membership of a database role you create in master
>for the specific users you want to have this ability.
>However, sp_readerrorlog and the underlying
>xp_readerrorlog can be used to read any file that the
>SQL service account has access to so be very careful !
>
>** Modifying system stored procedures is not supported
>
>--
>HTH
>
>Jasper Smith (SQL Server MVP)
>
>
>"Ray" <ray.x.bekker@gsk.com> wrote in message
>news:14e5b01c29473$5e148c30$8af82ecf@TK2MSFTNGXA03...
>> Hi,
>>
>> Hi I would like to know if there's a way of allowing a
>> user who is not part of the sysadmin group to view the
SQL
>> Server Logs through Enterprise Manager. I am aware of
>> sp_readerrorlog and viewing the log through notepad, but
>> is there another way using EM?
>
>
>.
>

Relevant Pages