Enterprise Manager hangs

• martinotis

  Newbie

  Points: 1

  More actions

  December 8, 2003 at 12:30 pm

  #65749

  Hello,

  I am using MS SQL server 7.0 with SP4 and Enterprise Manager hangs when I click on Current Activity.

  I am wondering if someone know what to do to solve this problems

  Thanks

  Martin

• Steve Jones - SSC Editor

  SSC Guru

  Points: 740241

  More actions

  December 8, 2003 at 2:11 pm

  #485181

  Does this happen everytime? I'd run profiler in the background and see what is actually completing. This runs a number of commands.

  You can also just run sp_who2 from QA and avoid running this in EM.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net