Stratergy
Aug 4, 1998
Hi
This is the error, I am getting.
Error 1608, Severity 21, state : 2
A network error was encountered while sending results to the front end .
Check the SQL server errorlog for more information
OS Error 232, the pipe is being closed
Error : 17824, Severity 10,
Unable to write to ListenOn connection `.pipesqlquery,loginname `sa`,
hostname `hpa4w320`
I know the cause as to why the error is generated, the REAL PROBLEM is that
the SQL server posts the above mentioned messages to the ERRORLOG, every fraction
of a second & the errorlog has grown to something like 1.2 Gig.
Does anyone know , how to prevent such a thing from happening.
Regards
Vedanth
View 4 Replies
Nov 15, 2007
Hi All,
I am facing a problem in my personal edition of sql server 2000. my this edition is hung after some time due to error "the schedular 0 appear to be hung in sql server 2000" and next error is "the schedular 1 appear to be hung in sql server 2000" i found the solution of this error i run sp4, after that this error wont appear to me in the error log , but the other problem occur which is "your server is configure for 8 concurrent process but currently 166 process running so the performance would be degrade" and after that i am not able to log into the server. Due to this concurrent process problem i want to go for sql server 2000 Enterprise edition. so what stragery should i follow for upgradation of server. any other alternative of this problem
Regards
Shashi Kant chauhan
View 1 Replies
View Related
