Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 49996 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 different steps will a sql server developer take to secure sql server?
Why we use the openxml clause?
What is query and its types?
What are tables in sql server?
What do you understand by user-defined function in the sql server?
What is inline variable assignment?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
How to drop an existing user defined function in ms sql server?
what is the sql equivaent of the dataset relation object ?
What are the steps you will take to improve the performance of a poor performing query?
How to change the password of a login name in ms sql server?
How to create percentile function?
What do you mean by recursive stored procedure?
When you use @@error and try-catch?
