sp_helpobjectdef

Description

(Component Integration Services only) Reports owners, objects, and type information for remote object definitions.

Syntax

sp_helpobjectdef [objname]

Parameters

objname

is the name of the object as it is defined in the sysattributes table. The objname can be in any of the following forms:

  • dbname.owner.object

  • dbname..object

  • owner.object

  • object

dbname and owner are optional. object is required. If owner is not supplied, the owner defaults to the current user name. If dbname is supplied, it must be the current database, and owner must be supplied or marked with the placeholder dbname..object. Enclose a multipart objname in quotes.

Examples

Example 1

Displays all remote object definitions in the current database:

sp_helpobjectdef

Example 2

Displays remote object definitions for the tb1 table owned by the database owner:

sp_helpobjectdef "dbo.tb1"

Usage

Permissions

Any user can execute sp_helpobjectdef.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

See also

Commands create table, create existing table, drop table

System procedures sp_addobjectdef, sp_dropobjectdef, sp_helpserver