Open .mdf created by SQL Server Management Studio

Posted on 2009-06-28
Last Modified: 2013-11-27
I have created a database under the SQL Server Management Studio, but when I tried to open this database from Visual Studio C# or Visual Web Developer I get a permission error saying
"This file is in use. Enter a new file name or close the file that is open in another program"

I am sure that i closed the SQL Server Management Studio and its instances.

What am I missing here?

Second question, is there a way to work with both applications Visual C# for instance and the SQL Management Studio on the same database? Since the studio offers more DB features

Thank you
Question by:cooldude87801
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 2

Expert Comment

ID: 24732672
An MDF file is a MS SQL Server database file; the file is in use when SQL Server service is running (and locking) the file.

You would have to detach the file from SQL Server if you want to manage the database separately.

Optimally, you can access some functions through VS when you connect to the database itself (through its existing SQL Server instance).

Author Comment

ID: 24733768
HI nasserd:

First how can i detach it from SQL Server?

Second, as far as I know, there are more funtionalities in SQL Management than in VS that's why I want to us both

Also, is there a way to generate SQL statements from my tables where I can copy and paste.

Thank you


Author Comment

ID: 24739556
I would appreciate any feedback regarding my questions:
1- Can use VS and SQL Management Server together to access one database
2- If not, how I can detach the database from one IDE so I can access through the other one
3- How I can generate SQL statements

Thank you in advance!!
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.


Expert Comment

ID: 24741712
SSMS (sql server mgmt studio) is only an IDE to the Sql Server engine.  That engine, which runs as a Windows Service, locks the database.

To detach a database, you have to go into SSMS, connect to the database server, then right-click the database to expose functions.  The right-click is the power of generating sql statements, too (although not complex ones).

For complex sql generators, you'll have to consider commercial software (a Bing or Google search should suffice).

To use 2 IDE's to interact with your database, you would use SSMS as you currently do... but DO NOT DETACH the database.  In VS you would connect to the database server engine (local)\SQLEXPRESS or whatever its name, then interact that way.

Author Comment

ID: 24761970
Hi nasserd,
I am trying to connect to the DB using VS as you have explained but I am getting an error as shown in the attached file.

Accepted Solution

cooldude87801 earned 0 total points
ID: 24781336
I am still waiting for an answer please

Author Comment

ID: 25286517
no one else provide me with an answer for my question

Author Comment

ID: 25286520
no one else provided me with an answer

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article surveys and compares options for encoding and decoding base64 data.  It includes source code in C++ as well as examples of how to use standard Windows API functions for these tasks. We'll look at the algorithms — how encoding and decodi…
As more and more people are shifting to the latest .Net frameworks, the windows presentation framework is gaining importance by the day. Many people are now turning to WPF controls to provide a rich user experience. I have been using WPF controls fo…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question