SET PROCID (T-SQL)

Returns the identification number of the stored procedure to DB-Library applications before sending the result sets generated by that stored procedure.

Syntax

SET PROCID {ON | OFF}

Remarks

When SET PROCID is ON, Microsoft® SQL Server™ returns the ID of the stored procedure. When SET PROCID is OFF, SQL Server does not return the stored procedure’s ID.

The SET PROCID setting is used only in DB-Library applications.

The setting of SET PROCID is set at execute or run time and not at parse time.

Permissions

SET PROCID permissions default to all users.

See Also