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 |
|
BobLewiston
Starting Member
29 Posts |
 Posted - 2009-04-05 : 23:13:59
|
| I've been working with SQL2008 AdventureWorks; specifically database AdventureWorks, table Person.Contact.I experimented with using a DataGrid control's DataSource property to add a new project data source to the DataGrid, although my code was written to access the database without using a DataGrid. My code was unable to do so because, naturally enough, the database was already in use by the DataGrid.However, when I removed the DataGrid, to my surprise the AdventureWorks database was just plain gone. That's right, not corrupted, but gone from the disk without a trace. The other databases (AdventureWorksDW, AdventureWorksDW2008, AdventureWorksLT, AdventureWorksLT2008, ReportServer$SQLEXPRESS, ReportServer$SQLEXPRESSTempDB) were still there, but not the database named simply "AdventureWorks".So I reinstalled AdventureWorks. Now here's the part where you all conclude I've lost my mind: AdventureWorks installed without any problem - but no database named simply "AdventureWorks". No "Person.Contact" table, even in any of the other databases. No sign of them, no explanation.But you can look up the AdventureWorks schema online and see that they DO exist. So I'm NOT insane after all - honest, fellas, I’m not dangerous, it’s all right to talk to me.So wha’d’ya think is going on here? |
|
|
EugeneLim11
Posting Yak Master
167 Posts |
Posted - 2009-04-06 : 02:27:36
|
| did you refresh your screen? Is it still missing? Try closing MSSQL 2008 and restarting it. Does it helps?check out my blog at http://www.aquariumlore.blogspot.com |
 |
|
|
BobLewiston
Starting Member
29 Posts |
Posted - 2009-04-06 : 09:09:29
|
| EugeneLim11:I rebooted the machine. No help.Is it possible the database IS there and SQL Server 2008 Express simply refuses to show it because it now "belongs to" another (ficticious) user that was somehow conjured into being by DataGrid control's DataSource property?(I can't just look for the files in Windows Explorer. These databases are somehow hidden in other files that I've never been able to locate.) |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-06 : 09:14:19
|
You may have to attach the database after installation.I had to manually attach the AdventureWorks database after installation.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
BobLewiston
Starting Member
29 Posts |
Posted - 2009-04-06 : 12:26:37
|
Peso:quote:
You may have to attach the database after installation.
Sounds like you may be on to something there. How do I "attach" a database?Also: I note that you are the Patron Saint of Lost Yaks, while EugeneLim11 is the Posting Yak Master. What's all this about yaks? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-06 : 13:09:05
|
In Management Studio, right click databases and choose attach...
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
|
|
the Brigadoon of databases