Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 52753 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
How to modify existing triggers using "alter trigger"?
What is field in algebra?
what kind of lan types do you know? : Sql server database administration
Explain syntax for dropping triggers?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is difference between delete and truncate commands?
What are types of subqueries?
Explain trigger classes i.e. Instead of and after trigger?
What is a trigger what are the advantages of trigger?
what method you can use to reduce the overhead of Reporting Services data sources?
What is the report builder?
What do you understand by the denormalisation?
how to determine the service pack currently installed on sql server? : Sql server database administration
How to connect of datebase with sql express.?
Explain the dirty pages?
