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 |
|
Abood
Starting Member
6 Posts |
 Posted - 2010-06-22 : 06:59:30
|
| Hi,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 off 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 ? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-22 : 09:43:28
|
| "i query the version in Query analyzer "You meanSELECT @@VERSION (that's the Server Engine version)or using "Help : About" in Query Analyser (that's the client tools version - and requires a separate upgrade from the Engine upgrade) |
 |
|
|
Abood
Starting Member
6 Posts |
Posted - 2010-06-22 : 10:03:32
|
| Thanks Kristen,i have used the above mentioned statement in addition to :SELECT SERVERPROPERTY('productversion')and i got the same result : 8.00.194 |
|
|
|
|
|
|
sql server 2000 not responding