New system procedures

Table 5-5 lists the new system procedures that support the Component Integration Services feature.

**Table 5-5: New system procedures for CIS**
System Procedure	Description
sp_addexternlogin	Creates an alternate login account and password to use when communicating with a remote server through CIS.
sp_addobjectdef	Specifies the mapping between a local table and an external storage location. sp_addobjectdef replaces the sp_addtabledef command.
sp_autoconnect	Defines a passthroughconnection to a remote server for a specific user, which allows the named user to enter passthrough mode automatically at login.
sp_configure "enable cis"	Enables or disables CIS. Default is 0 (disabled).
sp_defaultloc	Defines a default storage location for objects in a local database.
sp_dropexternlogin	Drops the definition of a remote login previously defined by sp_addexternlogin.
sp_dropobjectdef	Deletes the external storage mapping provided for a local object.
sp_passthru	Allows the user to pass a SQL command buffer to a remote server.
sp_remotesql	Establishes a connection to a remote server, passes a query buffer to the remote server from the client, and relays the results back to the client.