Difference between sql server 2000 and sql server 2005?

Answer Posted / pavan

lot of differences:
1. mirroring
2. transactional with updatable subscription
3. resource database
4. serialization

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by Active-Passive and Active-Active clustering setup?

749


What is the difference between commit and rollback?

673


How to generate create view script on an existing view?

742


What is a trigger what are the advantages of trigger?

694


How many databases instances are there in sql server 2000?

756






Write down the syntax and an example for create, rename and delete index?

723


What are the requirements to use odbc connections in php scripts?

808


What is SQL Server?

848


What is trace flag in sql server?

718


Explain how to send email from sql database?

735


Where sql server usernames and passwords are stored in a sql server?

661


What do you mean by data manipulation language?

764


What is reference section?

674


What are the different types of replication are there in sql server 2000?

761


What is schemabinding a view?

696