New system procedures

You implement and manage execution hierarchy for client applications, logins, and stored procedures using the five categories of system procedures listed in Table 5-10.

**Table 5-10: New system procedures for managing execution precedence**
Category	System Procedure	Description
User-defined execution class	sp_addexeclass sp_dropexeclass	Creates or drops a user-defined class with custom attributes or changes the attributes of an existing class.
Execution class binding	sp_bindexeclass sp_unbindexeclass	Binds or unbinds both predefined and user-defined classes to client applications and logins.
“On the fly”	sp_setpsexe sp_clearpsexe	Sets or clears attributes of an active session only.
Engines	sp_addengine sp_dropengine	Adds engines to or drops engines from engine groups; creates and drops engine groups.
Reporting	sp_showcontrolinfo sp_showexeclass sp_showpsexe	Reports on engine group assignments, application bindings, and execution class attributes.