Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 51338 Views
- Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain, I also Faced
- E-Mail Answers
Answer Posted / padmapriya
1.sql server 2005 include interprise manger and query
analyser together in same window we can open many window
tabs in same place but in 2000 it is in different.
2. sql server 2005 support more new datatype like xml
3. we can make more database 2(paw(20))-1 in 2005 in compare
to 2000 where not possible so much database
4. in storeprocedure we can write try catch statemenet in
2005 not in 2000
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
Can we use pragma autonomous_transaction in trigger?
What is a view in sql?
What is the difference between nvl and nvl2?
What do you mean by an execution plan? How would you view it?
What is the report builder?
What is pessimistic concurrency?
What are the types of database recovery models?
What is ddl and dml commands?
How many types of triggers are there?
How can you find out how many rows returned in a cursor?
What are the advantages of log shipping?
How to store and query spatial data?
How to update multiple rows with one update statement in ms sql server?
What is default port number for sql server 2000?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
