Results 1 to 2 of 2

Comparision between Sql Server 2000 and Sql Server 2005?

This is a discussion on Comparision between Sql Server 2000 and Sql Server 2005? within the Programming forums, part of the Web Designing & Development category; Hi.. Difference between Sql server 2000 and Sql Server 2005:- 1. In the Sql Server 2000 the Query Analyzer and ...

  1. #1
    Member
    Join Date
    Nov 2010
    Posts
    80

    Default Comparision between Sql Server 2000 and Sql Server 2005?

    Hi..

    Difference between Sql server 2000 and Sql Server 2005:-


    1.In the Sql Server 2000 the Query Analyzer and Enterprise manger are separate.and In the Sql Server 2005 both is combined in Management Studio.
    2.In the Sql Server 2005 the new datatype XML is used,whereas In Sql 2000 there is no such datatype.
    3.In the Sql server 2000 we can create the 65,535 database ,whereas In Sql Server 2005
    2(pow(20))-1 can be created.

  2. #2
    Member sheelharish's Avatar
    Join Date
    Nov 2010
    Location
    New Delhi
    Posts
    31

    Default Re: Comparision between Sql Server 2000 and Sql Server 2005?

    In the Sql server 2000 we can create the 65,535 database ,whereas In Sql Server 2005
    2(pow(20))-1 can be created.

Tags for this Thread