Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010

    Question Unanswered: SQL Server 2000 Enterprize manager not resoponding


    i have SQL Server 2000 installed on Windows 2003 Server machine. once i expand the tree of instance nodes or specific db sub-nodes it's not responding. i tried out changing the option of auto close and auto shrink to off and installed SP4. this solve for some time but it get hanging again at last.

    one thing i noticed also, is when i installed SP4 and restart the severer i query the version in Query analyzer and got 8.00.194 meaning there is Sp installed at all !!

    any help please ?

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    It sounds like you're working with your "sand box" server. Based on behavior of your SSEM, the MMC is messed up. Have you tried to open it from your workstation?

    Settings that you described have 0 (zero) effect on the MMC, and should be left alone, since you're not sure what they do, and you didn't mention what database you tried them on.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts