SQL SERVER - Sql Server2000 Vs Sql Server 2005

1. In 2005 enterprise manager and query analyzer given together, you can also open multiple windows in same enterprise manager.
2. In 2005 you can create 2(pow(20)-1) databases while in 2000 its 65,535.
3. 2005 introduced some new data types like ‘xml’.
4. In 2005 you can store large value and object type by using ‘max’ like varchar(max), nvarchar(max), varbinary(max).
5. In 2005 you can write try – catch statements in stored procedure.
   
   NSRI (shortcut to remember) in Sql Server 2005 –
   

   Notification services enhancement
   Service broker
   Reporting service enhancement
   Integration service enhancement