Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 52747 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 data compression?
Can you explain the disadvantages/limitation of the cursor?
List some advantages and disadvantages of stored procedure?
Explain cursor as data base object?
What are the encryption mechanisms in sql server?
How to make a column nullable?
Explain comment on transactions?
What does normalization do to data?
What are four major operators that can be used to combine conditions on a where clause?
How to change a login name in ms sql server?
What are audit control procedures?
What are the differences between lost updates and uncommitted dependencies?
Can we write ddl in trigger?
What is difference between commit and rollback when used in transactions?
Explain hostprotectionattribute in sql server 2005?
