Difference between sql server 2000 and sql server 2005?

By | |
  1. In SQL Server 2000 the Query Analyzer and Enterprise Manager are separate, whereas in SQL Server 2005 both were combined as Management Studio.
  2. In Sql 2005,the new datatype XML is used,whereas in Sql 2000 there is no such datatype
  3. In Sql server2000 we can create 65,535 databases,whereas in Sql server2005 2(pow(20))-1 databases can be created.
  4. In stored procedure we can write try catch statement in 2005 not in 2000
Tagged . Bookmark the permalink.

Leave a Reply