Execute SQL Stored Procedure

[Lindsay Estabrooks]

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
------------------------------

[Markus Hergeth]

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
------------------------------

[Pier Olivier Tremblay]

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.

[Lindsay Estabrooks]

I appreciate you sharing your experience. Merci monsieur.

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