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 a transact-sql statement?

539


What is the purpose of the master database?

606


How to delete duplicate rows in sql server?

581


What are the general features of sql server management studio? : sql server management studio

599


What is the difference between index seek vs. Index scan?

583






Ways to improve the performance of a SQL Azure Database?

103


What is rank function?

603


What are the three different part of rdl file explain them?

170


What is normalization process?

601


What is the concept of optimization?

573


What is the difference between ddl,dml and dcl commands?

613


Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

523


What is the difference between char, varchar and nvarchar?

581


How to edit table in sql server 2017?

514


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

539