Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 53170 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
How extra digits are handled with numeric data type literals?
What is system stored procedures?
What do you mean by sql server 2005 express management tools?
What are the limitations in ssrs on sql server express edition?
Explain how would you store your query in an SSRS report or a Database server?
Can we use trigger new in before insert?
Explain the different types of joins?
Can you use order by when defining a view?
What do you mean by a dependent functionality in a build?
How to see existing views in ms sql server?
What are a scheduled jobs?
What are cursors stored procedures and triggers?
What number aggregate functions are accessible there in sql?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How to disable triggers using "disable trigger"?
