• To see examples of what might break between earlier versions of SQL against 2005, try this link: http://geekswithblogs.net/influent1/archive/2007/01/04/102774.aspx

    There is one simple example of getting different results depending on compatibility levels right at the bottom of the page.

    Paul