How to kill the process id''s

• Bandlamudi Sridhar Babu

  SSC Rookie

  Points: 34

  More actions

  October 24, 2005 at 11:55 pm

  #76443

  Hi,

  Iam Sridhar Babu. i have one issue regarding SQLServer2000.

  iam installing .net application with backend MS SQL Server2000.

  it is working fine.

  when ever i acccess database through application, for each connecation one process will create. and when i close the application the process are closed automatically.

  but the process are going to sleeping mode.

  my problem is when i am going to uninstall the application

  it is showing the error message.

  Error 27506.

  Cannot frop the database 'database name ' because it is currently in use[3702]

  this is done with the help of Install Shield package.

  Please help me how to do this problem through programmatically. 

  BABU

   

   

   

  B.Sridhar Babu SE
  Canarys automations P ltd
  #135 7th Main, 4th Block
  Jayanagar
  Bangalore-560011
  sridhar.bandalamudi@ecanarys.com Tel: +91-26539915-24
  Mobile: +91-9449631468

• Sandeep Aparajit

  SSC Enthusiast

  Points: 178

  More actions

  October 25, 2005 at 12:17 am

  #599718

  Hi,

  You can kill the process using 'Kill' in SQL Analyser.

  Example you have spid =5.

  Kill 5

  will kill the process with SpID 5.

  Till you disconnect all the Database connections you will not be able to disconnect or drop the database.