Overview

You can use this Snap to execute a stored procedure in a SQL Server database and writes the values of OUT parameters to the output view.

Starting from SQL Server 2008, the result set from a Transact-SQL statement or stored procedure includes the count of the number of rows affected. This Snap fails to parse this extra information and may display an error (such as Failed to process result set). To fix the issue, add the following line to the stored procedure to turn off the output of the count: SET NOCOUNT ON

Snap Type

SQL Server - Stored Procedure is a Write-type Snap that executes an SQL Server stored procedure.

Prerequisites

None.

Support for Ultra Pipelines

Works in