Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 52848 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
Determine when to use stored procedure to complete sql server tasks?
Explain hostprotectionattribute in sql server 2005?
Explain what is cte (common table expression)?
What is the purpose of floor function?
Where are full-text indexes stored?
What is Lock table in SQL?
How to get a list of all tables with "sys.tables" view in ms sql server?
Can you move the resources after pausing the node? : sql server database administration
How do you create type- insensitive operator?
What are subqueries in sql server?
What are four major operators that can be used to combine conditions on a where clause?
Explain an automatic checkpoint
How to throw custom exception in Stored Procedure?
What is the difference between cartesian product and cross join?
What is subreport?
