SQL Server Stored Proc Execution

[simonpascoe]

Is it possible to execute SQL Server stored procedures? If so, how? Thanks.

[Support_Rick]

Just run a normal SQL Query ... like this:

Code: Select all

---

      <sql label="Call MSSQL Stored Proc" resourceId="MSSQL Rick&apos;s Laptop" version="1.0">
         <query label="Execute Stored Proc">
            <statement>EXEC proc_name</statement>
         </query>
      </sql>


[simonpascoe]

Thanks. My issue was that I was using a fully qualified name for the stored procedure instead of just the stored procedure name.

[WallyD444]

Hi, I have GA Director 4.1.1, and it's giving an "Invalid SQL statement" error trying to execute a stored procedure:

Code: Select all

---

<project name="Database Exec Test1" mainModule="Main" version="2.0" logLevel="normal" threadSafe="true">

   <module name="Main">

      <sql label="DBConnection" resourceId="WORK" autoCommit="true" version="1.0">
         <query label="query1">
            <statement>EXEC EXTRACT_DATA</statement>
         </query>
      </sql>

   </module>

   <description>WORKBENCH</description>
</project>

Any ideas?

thanks!

[Support_Rick]

Wally,

If you're not pointing to the current Database that has the Stored Procedure, you'll need to do that as well. Something like:

<statement>
Use MyDB;
Exec MyStoredProc;
</statement