Info on sp_prepexec

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » Info on sp_prepexec

Info on sp_prepexec

Rate Topic

Display Mode

Topic Options

Author

Message

Rootman

Posted Friday, November 08, 2002 8:59 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 03, 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

Simon Sabin

Posted Friday, November 08, 2002 10:23 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:18 AM
Points: 573, Visits: 95

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 »

Permissions