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?
Are you sure this is a table and not a view?
If you've just created it recently, make sure you hit the refresh button at the top, but not always syncing for me.
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.