- In SQL Server 2000 the Query Analyzer and Enterprise Manager are seperate,whereas in SQL Server 2005 both were combined as Management Studio.
- In Sql 2005,the new datatype XML is used,whereas in Sql 2000 there is no such datatype
- In Sql server2000 we can create 65,535 databases,whereas in Sql server2005 2(pow(20))-1 databases can be created.
No comments:
Post a Comment