known and “unknown” incompatibilities between sql

问题:

as usual, we'd like to think that there won't be any trouble migrating our applications to the latest sql version...

but...

but...

but...

well, just to be prepared, has anybody stumbled into some nasty incompatibility issue?

(for example, I remeber that after migrating from 2000 to 2005, one linked server we had to a sql 6.5 server stopped working)

回答1:

The msdn list of deprecated features is very comprehensive.

回答2:

The MSDN article Backward Compatibility for SQL Server 2008 covers all of the major components.