Steve
Reputation: 133
Tables won't show in SQL server 2008 object explorer
When trying to expand the tables on a database in the object explorer I get the following error:
“A severe error occurred on the current command. The results, if any, should be discarded. ”
The database was recently restored from a SQL server 2000 box. I can see two tables that are in the sysobjects catalogue but I can not drop or select them as it says the object does not exist.
Upvotes: 1
Views: 901
Answers (2)
Steve
Reputation: 133
What seemed to fix the issue was that the rogue tables had an owner that was a SQL server login account which was recreated but no schema was recreated. I recreated the schema which then let me browse the tables in the object explorer. From there I was able to delete the tables.
Upvotes: 1
Related Questions
- Schema objects not visible in SQL Server Management Studio 2008
- Why are my tables not showing up in SQL Server Management Studio's intellisense?
- Can't see created tables in Object Explorer - Microsoft SQL Management Studio
- Database objects are not showing on SSMS Object Explorer Azure DB
- Can't see table contents, etc. for SQL Server Compact Edition tables
- ASP.NET MVC 3, SQL Server: Tables not appearing in explorer, but they're there
- Cannot see table in Object Explorer, SQL Server 2005/2008
- Can't show database table in object explorer when created
- SQL Server 2008 Management studio - can't see tables, can run queries
- SQL Developer Table View not showing tables