Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 51334 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 happens if the update subquery returns multiple rows in ms sql server?
Explain “@@rowcount” and “@@error” in sql server?
What are the 7 disadvantages to a manual system?
What is difference between count (*) and count 1?
How to return the second 5 rows in ms sql server?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Can select statements be used on views in ms sql server?
What protocol does sql server use?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What is a data collection table?
How to replace null values in expressions using isnull()?
What happens when unicode strings concatenate with non-unicode strings?
How to Update from select query in sql server?
How do I setup a local sql server database?
What gets stored inside msdb database?
