how will i open a.mdf file database to sql management studio express?

File Management Add comments
file management
GaNdArA asked:

there’s an error stating that the physical file cannot be found, and that i don’t have a .mdf file editor installed.

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • NewsVine
  • Reddit
  • StumbleUpon
  • YahooMyWeb
  • Google
  • Yahoo! Buzz
  • TwitThis
  • Live
  • LinkedIn
  • Pownce
  • MySpace
One Response to “how will i open a.mdf file database to sql management studio express?”
  1. William V Says:

    A .MDF database cannot be “opened”. It must be attached to an existing (and running) SQL Server instance. If you have SQL Server Management Studio running, open a connection, and right click on databases. Choose “Attach” and point to the .MDF file. This will (attempt to) attach the database to the master database. If it works, the database will be visible in SSMS.

    hth

Leave a Reply

Website Design | Entries RSS Comments RSS Log in