Hi all,
Im an SQL Server Developer.....
Can anyone give me a good link which has the compatibility stuff among SQL Server Versions SAY FOR e.g. like SQL 2000 & Sql 2005...in specific?
Thanks in Advance
Shaun
Hi Shaun,
I'm not exactly sure what you're looking for, so I'm going to suggest a few topics. If these don't meet your needs, please provide additional details to help narrow this down a bit.
In Books Online, see
sp_dbcmptlevel (Transact-SQL).
Look for the heading "Differences Between Earlier Compatibility Levels and Level 90" . The table in this section lists specific compatibility differences between SQL Server 2000 (compatbility level 80) and SQL Server 2005 (level 90).
SQL Server 2005 Database Engine Backward Compatibility
Take a look at all four topics linked in this overview topic.
You might also want to consider using the Upgrade Advisor tool. See http://www.microsoft.com/downloads/details.aspx?familyid=451FBF81-AB07-4CCB-A18B-DA38F6BCF484&displaylang=en for more details and the download link.
Regards,
Gail
