Hi
I attached a database to SqlExpress.then moved the project to another place and deleted the last project(with it's mdf file).now, i can't attach database in new address to SqlExpress.
when i use from following connection:
it thrown an exception: 'Database already exsist'
and when i change to following Connection
it thrown an exception too:'Can not open database that requested to login'
I'm very confused...
How can i detach last database from SqlExpress?
I attached a database to SqlExpress.then moved the project to another place and deleted the last project(with it's mdf file).now, i can't attach database in new address to SqlExpress.
when i use from following connection:
Code:
Data Source=.\\SQLEXPRESS; AttachDBFileName=|datadirectory|dbName.mdf; Initial Catalog=dbName; Integrated Security=True;User Instance=true
and when i change to following Connection
Code:
Source=.\\SQLEXPRESS; Initial Catalog=dbName; Integrated Security=True;User Instance=true
I'm very confused...
How can i detach last database from SqlExpress?
Comment