I have recently upgraded databases from SQL Server 6.5, on the development
machine, to 7.0 on the production machine.
My initial attempts to transfer the whole database set, in one go (as
suggested by the 7.0 wizard), failed with Enterprise Manager "hanging" .
When I upgraded the databases one at a time, all seemed fine. The databases
are behaving as expected with all data, stored procedures, foriegn keys etc.
However any attempt to use the wizards to create diagrams or to use the
"design table" feature results in Enterprise Manager "hanging". Also I can
only successfully generate SQL scripts from any of the databases one table
at a time. If I try to generate the scripts for an entire database the
Enterprise Manager "hangs" again.
This installation of SQL Server 7.0 is part of a BackOffice SBS 4.5 package
and has not yet had SQL Server SP1 applied.
I am about to do a script rebuild of one of the databases from within
Enterprise Manager. Is there any known problems with Enterprise Manager that
could be causing this behaviour?
"hangs" means one of the following.
1. Script generation proceeds to 20% complete and then there is intermittent
disk activity with no apparent continuation of the script generation
process. Cancel script generation works - eventually.
2. Design Table produces some activity. then there is no further response
from the GUI. Task manager reports Enterprise Manager "not responding". End
task works with no apparent ill effects.
3. Create Diagram Wizard has the same effect as Design Table.
4. In all cases task manager reports CPU Usage fluctuating between 28% and
68% with memory usage constant. There is nothing else accessing the server
at this time.