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 |
|
shamsul
Starting Member
2 Posts |
 Posted - 2006-08-04 : 05:29:04
|
| After install ms sql server sp2 and veritas backup exec for windows version 9.1, I noticed that an error occurred on SQL Server Enterprise Manager. The error was "An error occured while trying to access the database information" when try to list all databases such as model, msdb and etc. summary information. There is no error when display the details information such as tables, views, users and etc. in every databases.Is there a wa y to solve this. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-04 : 07:04:09
|
| Besides the standard "install latest service pack 4" and "reboot"?None that comes to my mind.Peter LarssonHelsingborg, Sweden |
 |
|
|
shamsul
Starting Member
2 Posts |
Posted - 2006-08-08 : 04:39:31
|
| I can't upgrade to service pack 4 because the current SAP production server is still running on ms sql server 7.0 SP2 and under SQL Server Enterprise Manager 7.0 there is no such error to display summary information for every databases. This problem only occurred on the DR server for thsi SAP production. If I upgrade this DR server to SQL Server SP4, I afraid that SAP can't properly run on DR server. Every month, we will restore the latest SAP database to this DR server. That why i prefer to have the system at the same patch level. Is there any other way to solve this bug, maybe adjust some statement in registry file. |
|
|
|
|
|
|
error to display database summary information