Open a MDF file withMicrosoft SQL Server Management Studio Express9.00.1399.00

It works fine and I see the system tables and can make my own tables.

But how do I open a standalone MDF file with it? Or maybe it is a restriction ?

I am trying to get to the database for my personal start kit.

Hi,

For Microsoft SQL Server Management Studio Express 9.00.1399.00 question, you

post their questions to one of the appropriate SQL Server forums at:

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

Or depend on what you plan to do, you can also use VS/VWD IDE to connect to the database as well.

Thanks,

Lan

|||

or you can attached it manually at command prompt:

>SQLCMD -S (local)\sqlexpress -E

> select physical_name from sys.database_files where name = 'master'

> go

> exec sp_attach_db @.dbname=N'aspnetdb', @.filename1=N'[physical path]\aspnetdb.mdf'

> go

it should show up in your Microsoft SQL Server Management Studio Express after you attached it.

Hope that helps,

Lan