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
CREATE PROCEDURE SET

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.