SQL Server Issue

[happyIndian100]

Hi all,

Our sql server 2000 stops responding once a month.
when we truncate our 3 log tables it start working fine.

I want to know the reason whats causing SQL Server 2000 not to respond?

thanks in advance

 

[mrdenny]

We are going to need more information than you have provided. Such as the error message being returned to the client, any information in the ERRORLOG or event logs that may be related, etc.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com