What changed between the previous version of SQL Server and the current version?

Posted by

To view Verified answers click on the button below.

What are the new features introduced in SQL Server 2000 (or the latest release of
SQL Server at the time of your interview)? What changed between the previous
version of SQL Server and the current version?

This question is generally asked to see how current is your knowledge. Generally there is a
section in the beginning of the books online titled “What’s New”, which has all such
information. Of course, reading just that is not enough, you should have tried those things
to better answer the questions. Also check out the section titled “Backward Compatibility”
in books online which talks about the changes that have taken place in the new version.