New and changed system procedures

This section describes the new system procedures added and changes made to existing system procedures.

Table 2-6 summarizes the new system procedures:

**Table 2-6: New system procedures**
System procedure	Function
sp_dbextend	User interface for the automatic expansion process.
sp_ldapadmin	Creates an LDAP URL search string, lists an LDAP URL search string, or verifies an LDAP URL search string or login.
sp_listener	Dynamically starts and stops listeners on Adaptive Server on any given port on a per-engine basis.

Table 2-7 summarizes the changes made to existing system procedures.

**Table 2-7: Changed system procedures**
Procedure	Change
sp_addserver	Component Integration Services only – You can use pname to specify the hostname or IP address and the port of the server you wish to connect to.
sp_bindcache and sp_unbindcache	Although you can still use sp_bindcache and sp_unbindcache on a system tempdb, the binding of the system tempdb is now non-dynamic.
sp_cacheconfig	Dynamically starts and stops listeners on Adaptive Server on any given port on a per-engine basis.
sp_dbcc_evaluatedb	The output for sp_dbcc_evaluatedb is now more compact than before.
sp_dbcc_faultreport	Provides a new parameter @hard_only, which specifies a report of hard faults only.
sp_dboption	Now includes the checkpoint command. Users no longer need to execute checkpoint after executing sp_dboption.
sp_serveroption	The procedure has the following additional options: external engine auto start server cost server login
sp_sysmon	Now includes the cache wizard option, which allows you to monitor and configure data caches.