I am getting an error(XML parsing error: Not enough storage is
available to complete this operation.) while using OPENXML on server,
I think the problem is with bad version of MSXML.dll (someone said I
might be using 2.6 and NOT 3.0 Parser).
I want to know the service pack version of the SQL 2000 so that I would
then decide whether to apply SP3 or SP3a.
I would really appreciate if anyone can provide feedback on this.
Select @@version gives me this.
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000
00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Enterprise
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
xp_msver gives me this
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 524288 8.00.194
3 Language 1033 English (United States)
4 Platform NULL NT INTEL X86
5 Comments NULL NT INTEL X86
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT
8 FileVersion NULL 2000.080.0194.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL © 1988-2000 Microsoft Corp. All rights
reserved.
11 LegalTrademarks NULL Microsoft® is a registered trademark of
Microsoft Corporation. Windows(TM) is a trademark of Microsoft
Corporation
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 65630 NULL
15 WindowsVersion 143851525 5.0 (2195)
16 ProcessorCount 2 2
17 ProcessorActiveMask 3 00000003
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 2047 2047 (2146942976)
20 Product ID NULL NULL