System ESPs

In addition to xp_cmdshell, there are several system ESPs that support Windows features, such as the integration of SAP ASE with the Windows Event Log or mail system.

The names of all system ESPs begin with “xp_”. They are created in the sybsystemprocs database during SAP ASE installation. Since system ESPs are located in the sybsystemprocs database, their permissions are set there. However, you can run system ESPs from any database. The system ESPs are:

xp_cmdshell
xp_deletemail
xp_enumgroups
xp_findnextmsg
xp_logevent
xp_readmail
xp_sendmail
xp_startmail
xp_stopmail

See, System Extended Stored Procedures, in the Reference Manual: Procedures for information about the system ESPs, and the Configuration Guide for Windows discusses some specific features in more detail, such as Event Log integration.