Difference between sql server 2000 and sql server 2005?
Answer Posted / rohit
SQL SERVER 2000:
1.Query Analyser and Enterprise manager are separate.
2.No XML datatype is used.
3.We can create maximum of 65,535 databases.
4.Nill
5.Nill
6.Nill
7.Nill
8.Nill
9.Nill
10.Nill
11.Nill
12.Nill
13.cant compress the tables and indexes.
14.Datetime datatype is used for both date and time.
15.No varchar(max) or varbinary(max) is available.
16.No table datatype is included.
17.No SSIS is included.
18.CMS is not available.
19.PBM is not available.
20.PIVOT and UNPIVOT functions are not used.
SQL SERVER 2005:
1.Both are combined as SSMS(Sql Server management Studio).
2.XML datatype is introduced.
3.We can create 2(pow(20))-1 databases.
4.Exception Handling
5.Varchar(Max) data type
6.DDL Triggers
7.DataBase Mirroring
8.RowNumber function for paging
9.Table fragmentation
10.Full Text Search
11.Bulk Copy Update
12.Cant encrypt
13.Can Compress tables and indexes.(Introduced in 2005 SP2)
14.Datetime is used for both date and time.
15.Varchar(max) and varbinary(max) is used.
16.No table datatype is included.
17.SSIS is started using.
18.CMS is not available.
19.PBM is not available.
20.PIVOT and UNPIVOT functions are used.
getproductprice.com
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Do you know what are various aggregate functions that are available?
How to drop existing views from a database in ms sql server?
What is Federation and Federation Member?
How do use Having,Group by,Group function in SQL?
What is constraints and its types?
What is stored in the mssqlsystemresource database? : sql server database administration
What is log cache in sql server?
What is entity data services?
What are the difference between clustered and a non-clustered index?
what is difference between view and Dip.
Is mysql better than sql server?
What is the use of @@spid?
What is a result set object returned by odbc_exec()?
How to start and end transact-sql statements?
When would you use a before or after trigger?