errorlog

I have SQL 2000 with sp3. I can't recycle the errorlog. I have already
tried sp_cycle_errorlog and it does not do it. The errorlog is up to
300 MB. Any suggestions short of stopping/starting SQL ?
Raziq.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Raziq Shekha wrote:
> I have SQL 2000 with sp3. I can't recycle the errorlog. I have
> already tried sp_cycle_errorlog and it does not do it. The errorlog
> is up to 300 MB. Any suggestions short of stopping/starting SQL ?
Have you tried DBCC ERRORLOG?
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.