?
Solved

Open .mdf created by SQL Server Management Studio

Posted on 2009-06-28
8
Medium Priority
?
891 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
[X]
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
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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes how to add a user-defined command button to the Windows 7 Explorer toolbar.  In the previous article (http://www.experts-exchange.com/A_2172.html), we saw how to put the Delete button back there where it belongs.  "Delete" is …
If you have ever found yourself doing a repetitive action with the mouse and keyboard, and if you have even a little programming experience, there is a good chance that you can use a text editor to whip together a sort of macro to automate the proce…
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

752 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