bschelst/ March 22, 2017/ SQL-Server/ 0 comments

When tracing with SQL profiler, it returned a query using ‘sp_cursorprepexec’.
When executing the same query within SSMS, it failed with:


sp_cursorprepexec: The value of the parameter XX is invalid.


I managed to solve this by adding ‘+ 0x1000’ to the parameter

Share this Post

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>