Use create procedure to create a system ESP in the sybsystemprocs database. System procedures are automatically included in the sybsystemprocs database. The name of the ESP, and its procedural language function, must 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 Users Guide.
