(Component Integration Services only) Reports owners, objects, and type information for remote object definitions.
sp_helpobjectdef [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.
Displays all remote object definitions in the current database:
sp_helpobjectdef
Displays remote object definitions for the tb1 table owned by the database owner:
sp_helpobjectdef "dbo.tb1"
If no objname is supplied, sp_helpobjectdef displays all remote object definitions.
A server name is not permitted in the objname parameter.
Any user can execute sp_helpobjectdef. Permission checks do not differ based on the granular permissions settings.
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 |
|
Commands create table, create existing table, drop table
System procedures sp_addobjectdef, sp_dropobjectdef, sp_helpserver
