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.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment