Incompatibility between SQL Server 2000 and 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Incompatibility between SQL Server 2000 and 2005

Are there any article or webcast which point out the incompatibility between SQL Server 2000 and 2005? Thanks.
As it still in beta stages we may not have full information or benchmarks about the information, I found thishttp://www.informit.com/articles/article.asp?p=170820&rl=1 article which is nearest to the information. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
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. kishore
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
http://www.insidesql.de

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.
From SQL 2K5 DTS will be framed as Integration Services (IS) and I’m sure they are compatible. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>