Friday, June 6, 2014

Difference between SQL Server 2002 and SQL Server 2005

Hi Friends, I am explaining differences between sql server 2002 and sql server 2005

Sr.No
2002
2005
1
Query Analyser and Enterprise manager are separate.
Both are combined as SSMS(Sql Server management Studio).
2
No XML data type is used.
XML data type is introduced.
3
We can create maximum of 65,535 databases.
We can create 220-1 databases.
4
Exception Handling mechanism is not available
Exception Handling mechanism is available
5
There is no Varchar(Max) data type is not available
Varchar(Max) data type is introduced.
6
DDL Triggers is not available
DDL Triggers is introduced

RowNumber function for paging is not available
RowNumber function for paging is introduced
7
Table fragmentation facility is not available
Table fragmentation facility is introduced
8
Full Text Search facility is not available
Full Text Search facility is introduced
9
Bulk Copy Update facility is not available
Bulk Copy Update facility is introduced
10
Data Encryption concept is not introduced
.Cannot encrypt the entire database
11
Cannot compress the tables and indexes.
Can Compress tables and indexes.(Introduced in 2005 SP2)
12
No varchar(max) or varbinary(max) is available.
Varchar(max) and varbinary(max) is used.
13
Data Transformation Services(DTS) is used as ETL tool
SQL Server Integration Services(SSIS) is started using from this SQL Server version and which is used as ETL tool

No comments:

Post a Comment