Link to home
Start Free TrialLog in
Avatar of stbdevelopment
stbdevelopmentFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Attached database shows no tables in Management Studio

Colleagues of mine have taken a detached SQL Server 2005 database and attached it to SQL Server 2008 (R2?) server. Although they can run select statements against the tables they know are in the database, no tables are listed in the Management Studio tables treeview. Has anyone any idea how this could have happened?
ASKER CERTIFIED SOLUTION
Avatar of devlab2012
devlab2012
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of stbdevelopment

ASKER

Thank you. I will pass your comment onto my colleagues and update this question tomorrow.