Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-19 : 07:58:28
|
| Mark Havens writes "Hi -I have a remote SQL Server (2000 SP3a) that I manage, and today one of our developers told me that in Enterprise Manager, when he clicks on the views for a particular database, it times out, and doesn't list the views. This only happens on the views for this one database, and it doesn't happen when I'm connected (via Remote Desktop) to the server itself, and from other servers on its LAN.We can expand the views in EM on all the other databases on this server, and all the other objects come up fine, but just not the views for this one database.What can I do to troubleshoot this? The view listing comes up fine in the object browser in Query Analyzer, but not in EM.Any ideas are appreciated. Thanks!Mark HavensCCLIPortland, ORmhavens@ccli.com" |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-19 : 09:40:44
|
| the only time I like using the Enterprise Mangler is when I only have one hand available.SELECT * FROM INFORMATION_SCHEMA.VIEWS====================================================Regards,Sean RoussyThank you, drive through |
 |
|
|
|
|
|
EM times out when trying to display view listings