Known and "unknown" incompatibilities between SQL 2005 and 2008?

Question

as usual, we would like to think that there will be no problem porting our applications to the latest sql version ...

but...

Okay, just to be prepared, has anyone stumbled upon some nasty incompatibility issue?

(for example, I remember that after migrating from 2000 to 2005, one linked server we were using for sql 6.5 server stopped working)

+1

opensas May 10 '09 at 12:46

2 answers

u07ch · Answer 1 · 2009-05-10T12:59:40+0000

msdn list of deprecated functions is very detailed.

Kenny evitt · Answer 2 · 2011-07-08T15:52:17+0000

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