1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Difference between sql server 2000 and sql server 2005?

Question Posted / rohit

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


Please Help Members By Posting Answers For Below Questions

What are pessimistic lock and optimistic lock?

550

Do you know the isolation level that sql server support?

528

Explain ms sql server reporting services vs crystal reports?

500

Can a database be shrunk to 0 bytes, if not, why?

642

Can we write trigger for view?

559




Explain microsoft sql server functions?

543

Is sql server implemented as a service or an application? : Sql server database administration

512

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

496

What is replace and stuff function in sql server?

567

Why we use functions in sql server?

522

What is the difference between composite index and covering index?

513

What is 4nf in normalization form?

573

Name 3 ways to get an accurate count of the number of records in a table?

577

Where sql server usernames and passwords are stored in a sql server?

498

How to make remote connection in database?

599