November 25, 2018 at 11:52 am
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