I created an SQL database in Visual Studio 2005 Express Edition and would like to edit it in SQL Server Management Studio Express. The only databases listed in the Object Explorer of SQL Server MSE are the system databases (ones that are part of the SQL Server MSE).
If I dig through the directories, I can locate my database under the Visual Studio directory, but I am unable to open it. I get an error message stating, "There is no editor available for [my database]... Make sure the application for the file type (.mdf) is installed."
I'm sure that this is a ridiculously simple rookie mistake that I'm committing somehow, but I'm stumped. Any idea what I'm doing wrong?
What you need to do is "attach" your database in your management studio. This is supprisingly a goofy process, being that this is our newest implementation of a manager for SQL Express, here's some help to get you started.
http://msdn2.microsoft.com/en-us/library/ms190209.aspx
|||I tried it, and I think that it should have worked, but it didn't. I got a long string of error messages. It's probably just another bug that Microsoft will some day issue a patch for. When I attempted to add my review of the tip to the msdn website my computer locked up. That was kind of a metaphor for the entire experience. I've learned my lesson. Don't make databases in Visual Studio - do it in SQL Studio or MySQL.
|||I've never had an issue with the Management Studio, or SQL Express databases, I'm not sure what your experiencing, but they arent as unreliable as your making them out to be.
Sorry you couldnt get it fixed.
No comments:
Post a Comment