This is very strange! I have created my database on SQL 2008 Express R2 and connected it to DNN and all works fine. I can logon the site and I can use SQL on the site to run queries...all is well. BUT, on the server when I start Server Management Studio, I can't see the tables nor can I query them. The database is there, I can expand all the sections...but I can't see anything. No tables, No stored procedures, No views. I have logged on with several accounts... Windows administrator (win authentication), SA, and even the same user that I am using for DNN access and NONE can see the tables. Am i going crazy....or what! I hope someone can help me with this.

Thanks Leupold, but I think it is a bug. I found this post from Microsoft...I just need to know where to change this setting.

Posted by Microsoft on 4/28/2009 at 11:13 PM
Hi,
This is a bug in SMO. We are planning to fix this by next major release which will be SQL11.
This bug is actually not related to schemas at all but is related to the table owners. When we try to get the tables from the server in SMO, because of performance reasons we try to get their owners too by doing an INNER JOIN. Hence, if the user doesn’t have permissions to view the table owners, he is not able to see the tables also using SMO which is a bug.
Hence the workaround for this is, provide view permissions to the user on all the owners of the table. -Microsoft

So, Now where the heck do I set the permissions to view table owners??

-Mike

Yes, you were right about it pointing to a file name. I had to re-install with a newer version to get around the problem....but it is working now and I can see the tables in Server Management. Thank you very much for pointing me in the right direction.  It's great to have a knowledge source like yourself to get answers.

THANKS AGAIN!

-Michael