Difference between SQL Server 2000 and SQL Server 2005

These are the Major Differences between SQL Server 2000 and SQL Server 2005 :

1. SQL Server 2005 Integrates well with Visual studio and .Net streamlines development.

2. In SQL Server 2000, we can see the Enterprise manager and Query Analyzer as separate tools. Where as in SQL Server 2005, Management studio is a combination of both Enterprise manager and Query Analyzer, where we can develop, deploy, and troubleshoot SQL Server databases.

3. In SQL Server 2005, the security model separate users from objects, provides fine-grain access, enables greater control of data access. In addition to that all system tables are implemented as views, providing more control over database system objects.

4. Data Transformation Services(DTS) of SQL Server 2000, has been replaced with SQL Server Integration Services(SSIS).

5. New tools like SQL Server Management studio, SQL Server configuration Manager, Business Intelligence Studio have been introduced in SQL server 2005.

6. In SQL Server 2005, Native XML data can be stored, queried, and indexed in a SQL Server database.

7. In SQL Server 2005, New Snapshot Isolation (SI) level is provided at the database level with which users can access the last committed row using a transitionally consistent view of the database. This capability provides greater scalability.

8. SQL Server 2005 provides new enhancements like error handling, recursive query capabilities, relational operator PIVOT, APPLY, ROW_NUMBER and other row ranking functions.

9. New Business Intelligence features have been introduced like Analysis Services,Integration Services, Reporting Services and Data Mining.

10. Tight integration of SQL Server 2005 with Excel 2007 and Office SharePoint Server 2007.