Viewing 2 posts - 1 through 2 (of 2 total)
Have you tried getting the SPID of the process hung using the following command
select hostprocess from master..sysprocesses where spid=<Process ID>
Then kill that SPID in windows using task manager..
Regards
Frank Fernando
March 11, 2010 at 5:24 pm
#1132398
Looks like an issue with SPN. Do you have any web apps connecting to this sql server? i have seen this before and fixed the problem by creating some missing...
May 8, 2007 at 7:50 am
#704915