Extended Procedures Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Procedures Editor lets you modify the library name for an extended procedure. It also lets you work with dependencies and permissions.

Note: Extended Procedures are only available on the master database.

To edit an extended procedure

  1. Open an editor on the extended procedure. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Lets you provide a dynamic-link library (DLL) Library Name for the extended procedure.

Dependencies

For details on using this tab, see Working with Object Dependencies.

Permissions

For details on using this tab, see Working with Privileges and Permissions.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.