Friday, March 30, 2012

How to view error messages

SQL2000.
If somebody needs to view the error logs, do they need sysadmin
rights or can this be performed with another system role?
TIA.There is an undocumented command sp_Readerrorlog which allows you to read
error log through query analyzer but it requires the user to be member of
the securityadmin role.
--
-Vishal
"Stressed" <k@.c.co.uk> wrote in message
news:OHR2dyKQDHA.3192@.tk2msftngp13.phx.gbl...
> SQL2000.
> If somebody needs to view the error logs, do they need sysadmin
> rights or can this be performed with another system role?
> TIA.
>

No comments:

Post a Comment