Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 50013 Views
- Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain, I also Faced
- E-Mail Answers
Answer Posted / amit singh
1. In SQL Server 2000 the Query Analyzer and Enterprise
Manager are seperate,whereas in SQL Server 2005 both were
combined as Management Studio.
2. In Sql 2005,the new datatype XML is used,whereas in Sql
2000 there is no such datatype
3. In Sql server2000 we can create 65,535 databases,whereas
in Sql server2005 2(pow(20))-1 databases can be created.
| Is This Answer Correct ? | 202 Yes | 17 No |
Post New Answer View All Answers
what is difference between NULL and ISNULL in SQL Server 2008?
What is service broker?
What is microsoft sql server?
What is the meaning of resultset type_scroll_insensitive?
What were the latest updates to SQL Azure service?
How to run sql server 2005 books online on your local system?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Name 3 ways to get an accurate count of the number of records in a table?
How to count duplicated values in a column in ms sql server?
Explain what is log shipping?
Explain what is cte (common table expression)?
What is a system database and what is a user database?
When you should use a low fill factor?
What is right outer join in sql server joins?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
