Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 50037 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
What are examples of triggers?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Tell me about joins in database system and explain each in detail.
Explain insert into select statement?
What is encryption key?
What are the advantages of the mirroring?
how can you attach more than 20 ldf files in sql server
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How to delete existing triggers using "drop trigger"?
Explain forward - only cursors?
What are joins in sql and what are the different types of joins?
How can we get count of the number of records in a table?
Define master database?
What are recommended options to be used while using db mirroring? : sql server database administration
What is after dml trigger?
