IT Process Automation

Expand all | Collapse all

Execute SQL Stored Procedure

  • 1.  Execute SQL Stored Procedure

    Posted 01-07-2020 01:44 PM
    Hello Community,

    What is the best Database Operator to use to execute a Stored Procedure in MSSQL?

    Cheers,
    Lindsay

    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants
    ------------------------------


  • 2.  RE: Execute SQL Stored Procedure

    Posted 01-08-2020 03:01 AM
    Hi Lindsay,

    have you tried the Run Database Query Operator with "EXEC [DB-NAME].[dbo].[NameOfTheProcedure]" as SQL Expression?

    Regards,
    Markus

    ------------------------------
    Senior Technical Consultant
    Fujitsu Services GmbH
    ------------------------------



  • 3.  RE: Execute SQL Stored Procedure

    Posted 01-17-2020 09:50 AM
    I personnaly use the INSERT operator because i've found that when using Query or Select operator, the "row limit" applies to the number of rows the stored query is able to update :D


    I was wondering why my stored proc was creating only 512 rows to finally found that PAM was the culprit. Changing to INSERT operator solve it.


  • 4.  RE: Execute SQL Stored Procedure

    Posted 01-18-2020 12:00 PM
    I appreciate you sharing your experience. Merci monsieur.

    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants
    ------------------------------