Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 52755 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 is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Explain the etl (extraction, transformation, and loading)?
Explain the microsoft sql server delete command? : SQL Server Architecture
Explain unique key in sql server?
What is a self join in sql server?
Give an example of SQL injection attack ?
What is query parameter in ssrs?
How do we know if any query is retrieving a large amount of data or very little data?
What security features are available for stored procedure?
How do you Implement SSIS Packages in your Project?
What are the common performance issues in sql server?
 Explain what is sql override for a source taLle in a mapping?
What is transaction server auto commit?
Explain relational data?
What is implicit mode in sql server?
