Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 Profiler Query Replay Issue Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 4:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 6:27 AM
Points: 2, Visits: 13
Dear All,

We are upgrading our products' database from 2005 with 80 mode to 2008 with 100 mode. To verify the query compatibility and performance we captured all queries hitting the SQL-Server-2005 through profiler and tried to re-play the same in SQL-Server-2008 instance. During this replay activity we are facing error called Reply Internal Error with description as Failed to match corresponding value while executing certain type of query which looks PreparedStatement based (which internally uses cursor). I have attached the screenshot, please advise how to fix this error to move forward our upgrade testing. Thanks.

Rgds
Balaji


  Post Attachments 
sql profiler.jpg (3 views, 368.18 KB)
Post #1352098
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse