can't see error log

I tried to browse to my error log from EM, it's frozen.
why?sorry, I mean sql server log.
"Kevin" <pearl_77@.hotmail.com> wrote in message news:...
>I tried to browse to my error log from EM, it's frozen.
> why?
>|||my current log file is 7866872 byte. current-10/24/2005
I think maybe the log file is too big, I wonder if I can truncate the
current log file.
I ran sp_cycle_errorlog, but it doesn't close current log file and recreate
a new one.
do anyone know how to solve this problem?
"Kevin" <pearl_77@.hotmail.com> wrote in message
news:%23y3unRM2FHA.164@.TK2MSFTNGP10.phx.gbl...
> sorry, I mean sql server log.
> "Kevin" <pearl_77@.hotmail.com> wrote in message news:...
>|||Kevin,
Try restarting Enterprise Manager. Also, try running this in Query
Analyzer:
SP_READERRORLOG
HTH
Jerry
"Kevin" <pearl_77@.hotmail.com> wrote in message
news:e0K0$QM2FHA.3180@.TK2MSFTNGP10.phx.gbl...
>I tried to browse to my error log from EM, it's frozen.
> why?
>|||Hi
How big is your log?
If it is more than about 10MB, it will take a while to load.
You might have better success by opening it with notepad.
You may want to cycle it occasionally using sp_cycle_errorlog
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kevin" <pearl_77@.hotmail.com> wrote in message
news:%23y3unRM2FHA.164@.TK2MSFTNGP10.phx.gbl...
> sorry, I mean sql server log.
> "Kevin" <pearl_77@.hotmail.com> wrote in message news:...
>|||Does the sproc return an error message? Test box? You can try restarting
the SQL Server service...then try again.
HTH
Jerry
"Kevin" <pearl_77@.hotmail.com> wrote in message
news:eMqf9WM2FHA.1032@.TK2MSFTNGP12.phx.gbl...
> my current log file is 7866872 byte. current-10/24/2005
> I think maybe the log file is too big, I wonder if I can truncate the
> current log file.
> I ran sp_cycle_errorlog, but it doesn't close current log file and
> recreate a new one.
> do anyone know how to solve this problem?
>
>
> "Kevin" <pearl_77@.hotmail.com> wrote in message
> news:%23y3unRM2FHA.164@.TK2MSFTNGP10.phx.gbl...
>