Component Integration Services only Reports owners, objects, and type information for remote object definitions.
sp_helpobjectdef [object_name]
is the name of the object as it is defined in the sysattributes table. The object_name 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 object_name 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 object_name is supplied, sp_helpobjectdef displays all remote object definitions.
A server name is not permitted in the object_name parameter.
Any user can execute sp_helpobjectdef.
Commands create table, create existing table, drop table
System procedures sp_addobjectdef, sp_dropobjectdef, sp_helpserver
