October 24, 2005 at 11:55 pm
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
October 25, 2005 at 12:17 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply