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. Reporting service is available in 2005
No comments:
Post a Comment