Procedure errors out but SPID stays in sysprocesses

• S_Kumar_S

  SSCrazy Eights

  Points: 9037

  More actions

  March 31, 2020 at 7:54 am

  #3739207

  HI All

  Have any one of you faced a scenario where the procedure is aborted because of error/lost connection or any other reason but the spid that it used stays in sysprocesses table?

  The issue that I am facing is 1 start 5 threads of same proc using SSIS but once in a while what is happening is that one of the session gets killed. But I still see that sysprocesses table has the spid of that proc.

  Can some specific severity level error cause this?

   

   

  Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  April 1, 2020 at 8:10 am

  #3739535

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.