Solved

Open .mdf created by SQL Server Management Studio

Posted on 2009-06-28
8
885 Views
Last Modified: 2013-11-27
Hi,
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
0
Comment
Question by:cooldude87801
  • 6
  • 2
8 Comments
 
LVL 4

Expert Comment

by:nasserd
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).
0
 

Author Comment

by:cooldude87801
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

0
 

Author Comment

by:cooldude87801
ID: 24739556
Hi,
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!!
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 4

Expert Comment

by:nasserd
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.
0
 

Author Comment

by:cooldude87801
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.
DBerror.jpg
0
 

Accepted Solution

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

Author Comment

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

Author Comment

by:cooldude87801
ID: 25286520
no one else provided me with an answer
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

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…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 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