Info on sp_prepexec

  • Can anyone help. I have an app (3rd party) which calls sp_prepexec.

    I am getting the following error:

    Server: Msg 8179, Level 16, State 2, Procedure sp_prepexec, Line 3

    Could not find prepared statement with handle 1624.

    Can anyone shed any light on this?

    Please??

  • I believe it is an sql server internal extended procedure used by ODBC. So your client is not using it directly. It, I believe, harks back to the days when you prepare a statement before you execute it.

    What do you need to know for?

    Simon Sabin

    Co-author of SQL Server 2000 XML Distilled

    http://www.amazon.co.uk/exec/obidos/ASIN/1904347088


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

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

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