What are the differences between the SQL Server 2000 DB objects and SQL Server 2005 DB objects?

• pavanka143

  Newbie

  Points: 1

  More actions

  February 2, 2009 at 6:41 am

  #130261

  Hi All,

  We are planning to upgrade the database from SQL Server 2000 to SQL Server 2005.

  Please provide me a document/PPT/any link showing all the differences between the SQL Server 2000 DB objects(like tables,Stored Procedures,DTS packages,etc) and SQL Server 2005 DB objects.

  Thanks,

  Pavan.

• Rajesh Jonnalagadda

  Ten Centuries

  Points: 1032

  More actions

  February 2, 2009 at 7:18 am

  #936414

  Check this link

  http://www.sqlservercentral.com/articles/Administration/2988/

• GSquared

  SSC Guru

  Points: 260824

  More actions

  February 2, 2009 at 7:46 am

  #936428

  MSDN has whitepapers and articles on the differences. I'd look there.

  Also has advice on how to best use the upgrade wizard.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon