System extended stored procedures  Logging error messages

Chapter 1: Overview of System Administration

Creating system ESPs

Create a system ESP in the sybsystemprocs database using the create procedure command. System procedures are automatically included in the sybsystemprocs database. The name of the ESP, and its procedural language function, should begin with “xp_”. The uid of the stored procedure must be 1, the uid of the Database Owner.

For general information about creating ESPs, see Chapter 17, “Using Extended Stored Procedures,” in the Transact-SQL User’s Guide.





Copyright © 2005. Sybase Inc. All rights reserved. Logging error messages

View this book as PDF