sp_unbindexeclass

Description

Removes the execution class attribute previously associated with an client application, login, or stored procedure for the specified scope.

Syntax

sp_unbindexeclass object_name, object_type, scope

Parameters

object_name

is the name of the application, login, or stored procedure for which to remove the association to the execution class.

object_type

identifies the type of object_name as ap, lg, or pr for application, login, or stored procedure.

scope

is the application name or the login name for which the unbinding applies for an application or login. It is the stored procedure owner name (user name) for stored procedures.

Examples

Example 1

Removes the association between “sa” login scoped to application isql and an execution class. “sa” automatically binds itself to another execution class, depending on other binding specifications, precedence, and scoping rules. If no other binding is applicable, the object binds to the default execution class, EC2:

sp_unbindexeclass 'sa', 'lg', 'isql'

Usage

Permissions

Only a System Administrator can execute sp_unbindexeclass.

See also

System procedures sp_addexeclass, sp_bindexeclass, sp_dropexeclass, sp_showexeclass

Utility isql