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 15, “Using Extended Stored Procedures” in the Transact-SQL User’s Guide.