06-23-10, 04:31 #1Registered User
- Join Date
- Jun 2010
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 ?
06-25-10, 17:46 #2Registered User
- 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."