1.Difference between SQL Server 2000 and 2005

SQL Server 2000 SQL Server 2005

1.Query Analyzer and Enterprise Manager are separate

1.Both are combined as SQL Server Management Studio (ssms – 2008 onwards,sqlwb-2005)

2. No SSIS introduced

2. SSIS introduced

3.  No Compression 3. Compression was introduced
4. Bulk Copy (BCP) not possible 4. Bulk Copy (BCP) is possible
5. Database Mirroring is not there 5. Database Mirroring introduced with SP1.
6.  
 

2. 2005 – 2008

SQL Server 2005 SQL Server 2008
1.File Stream not there 1.File Stream was introduced
2. No backup Encryption 2. Backup Encryption introduced
   
   
   
   
 

 

Working on….for more points

Advertisements