Returns the identification number of the stored procedure to DB-Library applications before sending the result sets generated by that stored procedure.
SET PROCID {ON | OFF}
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.
SET PROCID permissions default to all users.
CREATE PROCEDURE | SET |