Tuesday, March 20, 2012

Can I Clear SQL Event Log

Hi,
Is there a way to clear the SQL Server Event Log without
stopping/starting the SQL service? I am running SQL Server 2000. I am
not talking about the transaction logs.
Thank You.
DanHi Dan
I assume you are talking about the SQL Server error log. You cannot clear
the log, but you can start a new one, by using the procedure
sp_cycle_errorlog.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Dan" <moro0012@.yahoo.com> wrote in message
news:1136338503.760968.10520@.f14g2000cwb.googlegroups.com...
> Hi,
> Is there a way to clear the SQL Server Event Log without
> stopping/starting the SQL service? I am running SQL Server 2000. I am
> not talking about the transaction logs.
> Thank You.
> Dan
>

No comments:

Post a Comment