Differences Between sql server 2000 and 2005

• BalaMunugoti

  Grasshopper

  Points: 23

  More actions

  December 20, 2006 at 10:44 pm

  #193545

  Hi

  I want to know the some main  differences between sql server 2000 and 2005.

  Is there any different tool  compare to 2000 and tell me tools like query analyser and exterprise manager.

  Thank you

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 21, 2006 at 12:16 pm

  #679518

  No more QA and EM in 2005...

  New tools called SQL SERVER MANAGERMENT STUDIO (SSMS)

  There are plenty of new feature and deprecations...

  http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/40a13a024a5fceeb/55f27470db401692?lnk=st&q=difference+between+sql+server+2000+and+sql+server+2005&rnum=1&hl=en#55f27470db401692

   

  MohammedU
  Microsoft SQL Server MVP

• Malcolm Leach

  SSCommitted

  Points: 1517

  More actions

  December 22, 2006 at 3:33 am

  #679672

  If you are thinking of moving a database from SQL 2000 to 2005 then you need to be aware that your schema may be broken by the move without you knowing about it. To see why please take a look at this page on our website.

  Malcolm
  DB Ghost - Build, compare and synchronize from source control = Database Change Management for SQL Server
  www.dbghost.com

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  December 22, 2006 at 7:48 am

  #679720

  nice scary advertising

  any upgrade should first be tested in a QA environment to find any problems. Then upgrade the least used SQL server in your environment to catch any other problems