2012 upgrade advisor issue

  • Hi,
    I was trying with testing upgrade advisor.

    Mysource machine- sql express 2008 R2
    I have 2 stored procs here which uses discontinued feature.
    a) takes backup 'WITH PASSWORD'-- works fine in 2008 R2 and fails in 2012, while excuting, whicch is an expected behaviour.

    b)second one is below proc with FASTFIRSTROW..which works in 2008 R2 and fails in 2012.
    CREATE PROCEDURE [dbo].[MYNEWPROC] AS
    BEGIN
    SELECT
    EMPNO
    FROM
    MYTESTDB.DBO.MYTESTTAB WITH (FASTFIRSTROW)
    WHERE
    EMPNAME = 'xxxxxxx'
    END
    GO

    I installed sql 2012 upgrade adviser in my 2008 R2 machine and ran it with profiler generated trace file and directly on engine as well..
    none of this scan reports this 2 as issues..

     any one know why is it not reporting.

    any help appreciated.

    thanks
    davis

Viewing 0 posts

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