Executing ESPs  Getting information about ESPs

Chapter 17: Using Extended Stored Procedures

System ESPs

In addition to xp_cmdshell, there are several system ESPs that support Windows features, such as the integration of Adaptive Server 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 Adaptive Server 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:

See the Reference Manual for information about the system ESPs. In addition, Configuring Adaptive Server for Windows NT discusses some specific features in more detail, such as MAPI and Event Log integration, which you implement using the Windows-specific system ESPs.





Copyright © 2005. Sybase Inc. All rights reserved. Getting information about ESPs

View this book as PDF