Calling normal stored procedures from Extended Procedures

Hot Topic

Setup RS for deployment and running reports by users
putting user accounts on the database
Overriding repeating totals from non-referenced slicer dimension
SP1 Database Services failed to install
Could not load file or assembly SQLXMLBULKLOADLib
Howto suppress FETCH output
SSIS Doubts
Remote SSIS connection problem
make XML column not case sensitive
Bug? Err Rows Not Filtering on truncation in delimited file types

SQL Server

Configuring Charts for more than one axis
Link problem in my script file
Transaction with SSIS / SQL Server / DB2
how to user defined tables in report model ?
How to create vertical text?
What interface does Management Studio use?
Value "+00000000000000" considered as NULL values in the last column
Microsoft SQL Server Mobile Edition data source
June CTP Report Model Creation using Analysis Services Datasource.
TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host

Calling normal stored procedures from Extended Procedures

Hi

I want to call a database stored procedure from an extended procedure. Can some one provide snippet of code (either in C or C++) to achieve the same

Thanks & Regards
Imtiaz

Answer this question

Calling normal stored procedures from Extended Procedures

  • BrianZim

    You have to make connection to server using ODBC or OLEDB to do this. Please take a look at the call escape sequence topic in Books Online. The url is mk:@MSITStore:D:\Program%20Files\Microsoft%20SQL%20Server%20Books%20Online\1033\odbcsql.chm::/od_6_035_5dnp.htm. You may have to change the path depending on your installation. You can also find samples in the SQL Server CD.

  • Calling normal stored procedures from Extended Procedures
Answer this question