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 |
|
mhavens
Starting Member
3 Posts |
 Posted - 2005-08-18 : 12:19:41
|
| 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 |
|
|
SQLTEAMSteve
Starting Member
8 Posts |
Posted - 2005-08-19 : 12:31:33
|
| What is the description of the server the box resides on? Is there additional services running, such as reporting services, etc? Is this an OLTP dB that is highly transactional and hammered all day long, etc?_________________________Stephen R Montgomery |
 |
|
|
|
|
|
|
|
View listing in EM times out for 1 database