Visual Basic

"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=work;Data Source=pcjordi2009\sqlexpress"

"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Master;Data Source=pcjordi2009\sqlexpress"

ALTER DATABASE [AdventureWorks] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
USE master;
GO
sp_detach_db 'AdventureWorks';

I are Troll

edmonson wrote:

When I execute ALTER DATABASE... the DB enters in Single User Mode (An icon appears on Db List in Mabagement Studio, but when execute detach it fails reporting that Database is in use

string cs = "Server=.\\SQLEXPRESS;Database=master;Trusted_Connection=True;";
using (var con = new SqlConnection(cs))
using (var cmd = new SqlCommand())
{
    con.Open();
    cmd.Connection = con;
    cmd.CommandText = @"ALTER DATABASE [AdventureWorks] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;";
    cmd.ExecuteNonQuery();
    cmd.CommandText = @"sp_detach_db 'AdventureWorks';";
    cmd.ExecuteNonQuery();
}

I are Troll

edmonson wrote:

Any idea, why the server process stopped ??

I are Troll

edmonson wrote:

Yes, every time I attached again (without exiting from application) and try to get data, the problem appears.

I are Troll

orvries wrote:

Still need help to communicate with e.g. the forementioned website, but others as well.

I are Troll

faizalfz wrote:

it very urgetn for an assignment