Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 53173 Views
- Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain, I also Faced
- E-Mail Answers
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
What is the difference between a local and a global temporary table?
What factors you will consider calculating the storage requirement for that view?
Explain steps of normalization?
What is join query?
What is the meaning of resultset type_scroll_insensitive?
Does sql server 2000 full-text search support clustering?
What are the different types of sql server replication? : sql server replication
What is the difference between ddl,dml and dcl commands?
What is the difference between for auto and for nested?
Why are you getting errors when creating a new odbc dsn?
What is data set in report?
How to declare and use cursor variables?
What is the difference between ‘having’ clause and a ‘where’ clause?
Which are the olap features?
What are types of subqueries?
