Have used Visual Web Developer 2008 to make ASP application, with SQL server 2008 R2 Express for database. Works very nicely.
However, when I come to use Management Studio Express 2008 R2, I cannot see all my tables.
The ones I CAN see were created by the MS script that creates membership tables (and are called dbo.aspnet_membership etc), presumably because the owner of the tables was specified as 'dbo'.
The ones I can't see from Management Studio are the ones I created. I never specified an owner.
I think this is a permissions issue, but I can't fathom it. There's only ever been me on my development machine (laptop) doing it all, hence always the same log ins.
Running Management Studio as Adminstrator doesn't help.
I can't even ask Management Studio who own's the tables that I can't see because Management Studio can't see them so rejects the script.
Any ideas/links very (very) welcome !
**** Actually, it is even wierder. The tables in Management Studio have full structure, but are empty. But if I look at them in Visual Basic 2008 they are full !!! And...if I create a table in Management Studio it does not appear at all in Visual Basic, and likewise, a table created in Visual Basic does not appear at all in Management
View Complete Post