I am trying to use SQL Server Management Studio and bring in an .mdf file that is already listed in
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA
There are a lot of other .mdf files listed there as well. The only one that appears in Object Explorer under
HKRAM\SQLEXPRESS(SQL Server 10.0.1600-HKRAM\my name\)
is Auburn Blue, which I created in MSFT SQL Server Management Studio. The file I want I created in VWD 2008 Express. It also resides in ...My Documents\Visual Studio 2008\WebSites\AuburnSQL\App_Data. Its size is the same but its Date Modified is a couple days more recent.
I can create a new database with the Database\New Database command. Where is the command to open an existing database?
What am I missing?