SQL Server Performance

Incompatibility between SQL Server 2000 and 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by pcsql, Mar 10, 2005.

  1. pcsql New Member

    Are there any article or webcast which point out the incompatibility between SQL Server 2000 and 2005?


  2. satya Moderator

  3. kish New Member

    Ofcourse there are many enhancements in 2005.
    One thing I have read about is Database Mirroring which is a enhanced version of Log SHipping in SQL 2000.

  4. FrankKalis Moderator

    Do a search on my site for "2005". That is the upper right corner next to the date. Should return 32 hits. Most hits are english links back to Microsoft. Maybe you find something usefult there.

    Frank Kalis
    SQL Server MVP
  5. rweinstein New Member

    One they mentioned at the recent PASS event in NY was that you cannot upgrade a SQL server that has a null sa password. You must change the sa password to a value and then upgrade.

    I know it was a marketing convention, but there didn't seem to be that many issues with upgrading. Maybe some really complex DTS packages might not upgrade, but they should still run.
  6. satya Moderator

    From SQL 2K5 DTS will be framed as Integration Services (IS) and I'm sure they are compatible.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page