We use sql server 6.5 (Microsoft SQL Server 6.50 -
6.50.416 (Intel X86) )
This happened two times so far:
A process was killed using the kill command. No user can
get into any of the databases in that server. We tried to
stop and start sql executive and that did not work. We
tried to stop and start MSsqlserver and that did not work
either. Finally we needed to bring the server down and
up. The sql server error log had the following:
spid 35: process id 34 killed by hostname ... host process
id ...
spid 35: process id 29 killed by hostname ... host process
id ...
then there is a series of stack dump messages from the
server
there is a series of stack dump messages from spid 34.
Any help will be appreciated!