Clever Geek Handbook

SQL Server Mgt Studio not showing table?

I have a table in SQL Server 2000 Standard Edition called "dbo.T668" (don't blame me for the naming convention).

I am working on a server using SQL Server Management Studio 2005 and for some strange reason I cannot see the table at all in the table list. I see all the other tables, but not this one.

If I open the query editor and type "select * from dbo.T668" it will return all records, so I have permission to access and select from the table - is there an option that allows you to access the table but not see it in SQL Manager? Or is it an incompatibility between SQL 2000 and SQL 2005?

0


source to share


3 answers


Are you sure this is a table and not a view?



+2


source


If you've just created it recently, make sure you hit the refresh button at the top, but not always syncing for me.



+2


source


DOH!

Did sp_help on it and you, right, it kind of ..... there are like 2000 tables in this database, so I guess I just missed it.

Argh.

0


source






More articles:


All Articles