| Author |
Error with OPENXML
|
|
| m.ramana@gmail.com 2005-06-07, 9:23 am |
| 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 M
icrosoft SQL Server
2 ProductVersion 524
288 8.00.194
3 Language 1033 Engl
ish (United States)
4 Platform NULL NT INTEL X86
5 Comments NULL NT INTEL X86
6 CompanyName NULL M
icrosoft Corporation
7 FileDescription NU
LL SQL Server Windows NT
8 FileVersion NULL 2
000.080.0194.00
9 InternalName NULL
SQLSERVR
10 LegalCopyright NU
LL =A9 1988-2000 Microsoft Corp. All rights
reserved.
11 LegalTrademarks N
ULL Microsoft=AE 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 6563
0 NULL
15 WindowsVersion 14
3851525 5.0 (2195)
16 ProcessorCount 2
2
17 ProcessorActiveMa
sk 3 00000003
18 ProcessorType 586
PROCESSOR_INTEL_PEN
TIUM
19 PhysicalMemory 20
47 2047 (2146942976)
20 Product ID NULL NULL
| |
| Simon Hayes 2005-06-07, 1:23 pm |
|
<m.ramana@gmail.com> wrote in message
news:1118151695.263944.198450@o13g2000cwo.googlegroups.com...
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.
<snip>
See here:
http://support.microsoft.com/defaul...kb;en-us;321185
Your installation has no servicepack installed; the current one is SP4.
Simon
| |
| Erland Sommarskog 2005-06-07, 8:24 pm |
| (m.ramana@gmail.com) writes:
> I want to know the service pack version of the SQL 2000 so that I would
> then decide whether to apply SP3 or SP3a.
Since SP3 gives you protection aganist the slammer worm, you really
should install SP3. Or SP4 which has been for some time now.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
| |
| Victor 2005-06-08, 9:23 am |
| Thanks for the info. I will go a head and install service pack 4.0
Hope that will fix the error
| |
|
|
| Victor 2005-06-08, 1:23 pm |
| I am guessing it will need a restart so waiting untill night to install
SP4 on production server. Will post my feedback
|
|
|
|