Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
monelogg
Starting Member
7 Posts |
 Posted - 2013-10-23 : 10:46:49
|
| Hi, I want to load AdventureWorks but when I loaded the program gave me this error: TITLE: Microsoft SQL Server Management Studio------------------------------There is no editor available for 'C:\adventure\adventure\AdventureWorks2008R2_Data.mdf'.Make sure the application for the file type (.mdf) is installed.------------------------------BUTTONS:OK------------------------------What should I do to prevent this error? Thanks for answering... |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-23 : 10:53:00
|
| What command are you using? If you are using File -> Open for the .mdf file, that is the not what you should be doing. Attach the database to the server. Here are the instructions: http://technet.microsoft.com/en-us/library/ms190209.aspx#SSMSProcedure |
 |
|
|
monelogg
Starting Member
7 Posts |
Posted - 2013-10-23 : 11:29:20
|
| Thank you for answering it was helpful.First time I loaded .mdf and .log files to C:\ but, the folder that I need to load "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\"After this step I did attach and it worked. |
|
|
|
|
|
|
AdventureWorks Loading Problem