Tables got hidden.

[manohars]

I'm working as a development DBA.

Everyone is given password for sa in our environment. Yesterday, all the tables were made hidden by one of the developers. Though, tables were there, they were hidden in enterprise manager. Is there any option for such a setting? If so, what's it?

Thanks in Advance,
Manohar

 

[ecobb]

Is this what you're talking about? faq183-3092

When you say "all the tables", do mean every table in the database, or just the system tables?



Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

 

[manohars]

All the user tables were hidden.

Manohar

 

[JBaileys]

I have seen instances where tables were hidden and a table refresh caused the tables to appear. This is often the case when creating a new table.

See if that is the problem: Right click on the db and select refresh.

 

[manohars]

No, it is in the refreshed state only. Still they are not visible.

 

[JBaileys]

Are you able to see the tables in query analyzer on the object view (left pane)?

Your request is quite unusual.

 

[manohars]

I understand that mine is unusual.

The objects are visible in Query Analyzer.

Manohar