Process ID %dis not a valid process ID. Choose a number between 1 and 32817.

• New2SQL-343122

  Default port

  Points: 1461

  More actions

  September 16, 2010 at 10:44 pm

  #103987

  Hi,

  unable to kill any of the process in the database.

  while using Kill 420 i am getting below error.

  Process ID 420 is not a valid process ID. Choose a number between 1 and 32817.

  however, other DBAs are suggesting for reinstalling the sql server but its not possible for me to change to other server since its production.

  Anyone can help me fix this issue.

  Using SQL 2k with SP2

  Thanks

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  September 19, 2010 at 11:14 pm

  #1223800

  Try doing a CHECKDB on master

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  September 19, 2010 at 11:24 pm

  #1223810

  Is spid 420 a valid sessionID? If you query sys.processes, is it there?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 20, 2010 at 1:00 pm

  #1224317

  What is the problem you are trying to solve by directly killing a process?

  As Gail has asked is this process listed in sysprocesses?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question