Deprecation Final Support - Set Rowcount

  • BrainDonor

    SSCoach

    Points: 19225

    I've run a server-side trace on our Development server for a while (2008R2), looking for anything under 'Deprecation Final Support'.

    So far two commands have come back - we have something using DATABASEPROPERTY and a few bits that use SET ROWCOUNT.

    Now when I look in BOL for DATABASEPROPERTY it clearly states that it will be removed in the next version (which will be 2012). However, there is no such warning for SET ROWCOUNT and it even appears in the provisional BOL for 2012.

    Does anybody know how I can find out for certain if it will be removed?

    Thanks.

    Steve Hall
    Linkedin
    Blog Site

  • Silverfox

    SSC-Insane

    Points: 23150

    BrainDonor (2/2/2012)


    I've run a server-side trace on our Development server for a while (2008R2), looking for anything under 'Deprecation Final Support'.

    So far two commands have come back - we have something using DATABASEPROPERTY and a few bits that use SET ROWCOUNT.

    Now when I look in BOL for DATABASEPROPERTY it clearly states that it will be removed in the next version (which will be 2012). However, there is no such warning for SET ROWCOUNT and it even appears in the provisional BOL for 2012.

    Does anybody know how I can find out for certain if it will be removed?

    Thanks.

    I could be wrong, and would welcome comments from others. But SET ROWCOUNT, is deprecated and not discontinued, DATABASEPROPERTY is discontinued and is replaced with DATABASEPROPERTYEX.

    SET ROWCOUNT still works in sql 2012 RC0 and is only deprecated in the use of it with INSERT, UPDATE and DELETE operations.

    As SQL 2012 is still only release candidate, functionality and features are subject to change, and your decision might have to wait until there are more definite information about what is truely discontinued.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

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