Sql Server 2000 & Sql Server 2005

Dear All

Is there is a big defference between Sql Server 2000 and Sql Server 2005 and if  i studying thesql server 2000 about  40% or 50% from it..can i upgrade and styding 2005 or i must completing studying sql server 2000 more enough.Please i want a good and practical advise.(i can't get the chance to develope a real life database with sql server2000 until this moment.)
Many Thanks 4 All.
11/14/2005 1:34:59 PM
📁 asp.net.free-for-all
📃 9281 articles.

💬 1 Replies


A lot of the concepts that are in SQL 2000 will still apply, such as data types, table design, indexes, pk/fk relationships, and such...  DTS has changed completely; in addition, SQL 2005 adds a lot of new features to learn about (such as XML indexes, BIDS [new DTS], notification services).  I would think that in studying 2005 that there would be a complete set of information available; that is, you should find information that was for 2000 now available for 2005?  When you mean study, you mean online information, or did you purchase books, or what?


"Trust in the Lord and do what is good; dwell in the land and live securely. Take delight in the Lord, and He will give you your heart's desires" (Psalm 37: 3-4).
11/14/2005 1:48:00 PM