Post reply

what doesn't work in compatibility mode 8?

  • December 8, 2008 at 3:08 am

    #203797

    I'm going to be working on a database on a 2005 sql server but the db is running under compat level 8 i.e. SQL 2000.

    I was doing some tests to see what I could do and couldn't do, and was surprised to see that I could write (and successfully execute) a stored procedure with a CTE and row numbering. I didn't expect to be able to profit from any of the features new to 2K5.

    Can I assume that all new features will work as per 2K5? Does anyone have anything 'official' they can share with me?

    Thanks,

    David.

  • December 8, 2008 at 5:02 am

    #909086

    As an example, the old syle outer joins using *= won't work in SQL2005 compatibilty.

    Look up "compatibility level" in SQL2005 BOL for the official list.

  • December 8, 2008 at 5:09 am

    #909090

    Hi Ian,

    I think you've misunderstood my question.

    *= syntax will work under compatibility mode 8 (2K). It wont under level 9 (2K5).

    I was talking about 2K5 features that still work under 2K compatibility mode.

    Hope this is clearer.

    David.

  • December 8, 2008 at 6:30 am

    #909114

    There seems to be a parallel thread running which may answer your question.

    http://www.sqlservercentral.com/Forums/Topic407783-146-1.aspx

  • December 8, 2008 at 7:44 am

    #909137

    Thanks Ian, that's a useful thread indeed!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply