Close connection of SQLExpress!

Hi,

I write a .NET Windows Form that connect to SQLExpress datafile. After updating data, I want to zip the .mdf file and send email. However, I got an exeption that the .mdf file is used by other thread so I cant zip. Even I try to close all connection, I still cant zip.

Is there any way to detach/unlock .mdf file connecting by SQLExpress?

MA.

Hi,

if you are sure you closed down all conenctions, you can use the sp_detach command to detach the database. if you want to close all connection from the server side first you will have to use the ALTER DATABASE command first and change the state of the database to a SINGLe or admin mode.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Unfortunaterly, I dont control the connection but I want to force to close all connection from the client side (using C# code).

MA.

|||

Hi MA,

Jens is exactly correct, you'll need to force the database into single user mode:

ALTER DATABASE pubs
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE

This will rollback all transactions and then you can detach the database as you like. I'm not sure what you mean you don't control the connections. If you can not connect to the database, then you can not close it's connections and you will not be able to close the connections.

Mike

Client Machine accesing sqlexpress

This may a silly question but....

I wrote a vb 2005 application that access sqlexpress for data using sqlconnection (.NET). The program works fine. When I run debug on my code that is in my laptop, it access my xp server box with sqlexpress running and I see all my data in my application. My question is..When I compile this program and install it on a client machine that has no sqlexpress tools, no SQLCMD etc....will the application run and access the xp server box, or do I have to install something on the client machine.

thanks

hi,

your "remote client pc" does only need your app and the .Net Framework, which installs all the required libraries to connect to local and remote SQLServer instances..

regards