• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

Can't See Existing Tables in SQL server 2005 express??!

OK, this is weird.

I have refreshed, restarted MS SQL Server Management Studio Express, but still, I cannot see the tables which it claims already exist.

Even from MS C# 2005, I cannot see any tables.

I can drop the tables, and I can re-create them, both at will, but I can't see them...

I include an image as proof...
SP32-20090417-140844.png
0
yaronusa
Asked:
yaronusa
  • 2
2 Solutions
 
Faiga DiegelSr Database EngineerCommented:
Check the database connection.. you might be creating and dropping it under master, model. msdb or temp databases.
0
 
mvgeertruyenCommented:
agree with faiga16; most of the time the drop down box says 'master'. Also different with previous versions is that the tree on the left needs a refresh after a create statement.
0
 
yaronusaAuthor Commented:
ok, you both are right, the tables ended up going into 'master'... thank 4 helping a n00b
0
 
yaronusaAuthor Commented:
thanks all!
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now