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

Info on sp_prepexec Expand / Collapse
Author
Message
Posted Friday, November 8, 2002 8:59 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 3, 2009 9:30 AM
Points: 489, Visits: 489
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??




Post #8046
Posted Friday, November 8, 2002 10:23 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 13, 2014 10:40 AM
Points: 573, Visits: 107
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
Post #46141
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse