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 |
|
kpgraci
Yak Posting Veteran
68 Posts |
 Posted - 2011-05-04 : 16:07:18
|
| As I understand it, a user instance database is a detached mdf+log file that the asp.net runtine creates a sql server instance for on the fly. I use them for dev work becuase it's easy, and some production stuff when the db load is light.Can one of these files be managed with a tool like sql server managment studio express? If so I can't do it, when I try to attach the database or otherwise open it it always complains that it cannot open the database.I can manipulate the database in visual studio somewhat, except for the case when the user instance db file has been upgraded to 2008R2, becuase apperantly VS can only read 2008, not 2008R2.So once a user instance file has been upgraded to 2008R2 how can I manage it???kpg |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-04 : 16:21:34
|
| I would suggest installing a local Developer or Express edition of SQL Server and attaching your database to that. Then you can have VS connect to that instance to use the database rather than on-the-fly attaching. |
 |
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-05-06 : 07:42:18
|
| might be your VS version is older because R2 is the latest Release of SQL Server 2008 so apply service packs or cu for VS to read R2 databasesRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
|
|
|
|
|
|
|
|
how to manage a user instance 2008R2