SQL Server Performance

XML vs SQL server 2000

Discussion in 'T-SQL Performance Tuning for Developers' started by luma, Jul 4, 2005.

  1. luma New Member

    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
  2. FrankKalis Moderator

    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)
  3. dineshasanka Moderator

    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
  4. luma New Member

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

    No, none that I remember. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
  6. dineshasanka Moderator

    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)
  7. luma New Member

    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
  8. FrankKalis Moderator

  9. luma New Member

    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 ?


  10. FrankKalis Moderator

  11. luma New Member

    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 ?
  12. FrankKalis Moderator

  13. luma New Member

    Nevermind, thanks, Lubo
  14. FrankKalis Moderator

Share This Page