SQL Server Performance Forum – Threads Archive

XML vs SQL server 2000

Do I need instal Service Pack 3 for SQL Server 2000 for development? I develop some application on SQL Server 2000 and I need import XML file(s) to table. Thanks , Lubo

I don’t think you need to install SP 3 in order to import XML files. However, it is generally not the worst idea, to stay almost current with SP’s as they offer bug-fixes, and sometimes new and/or improved functionality. The most current one is SP4, btw. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

No you don’t need sp 3 for the XML developments. But there are bugs which are fixed from sp3. so better to install it

I download sql sever service pack. Are there any complicated steps during the install process ?

No, none that I remember. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

quote:Originally posted by luma I download sql sever service pack. Are there any complicated steps during the install process ?

not at all,
just click the setup file .
but as a precautions take backups of your databases. but I have installed the sp without backing up databases many times(May not be a godd practice)

I installed service pack3 and msde. I am not good in english. Maybe I had a problem with subscribe install…. I don’t know. How can I see that I install it ok ? in what application ?
Thanks, Lubo

Fire a SELECT @@VERSION from Query Analyzer and compare your results to this:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37 —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Frank , I did it… The result message of this action in window of Query Analyzer is *** Microsoft SQL Server 2000 – 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1) ***
When I clicked to your linkhttp://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
I saw many results. One of them is 8.00.760 > 2000 SP3/SP3a …. It means I was successful ?

Yes! —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Hi, Frank may i send you my xml files. There is many structures. I need to do with some of them. But higher name has not constatnt name …May I send you this file ?

Sorry, but I have no experience with XML. I’m afraid I can’t help you with XML. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Nevermind, thanks, Lubo

Dang, just remembered that there is a dedicated MS newsgroup for XML question. They should be able to provide quick help.
http://www.microsoft.com/communitie…585-8382-400a-ac0e-0959bc096822&lang=en&cr=US —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

]]>