System procedures are created by installmaster at installation. They are located in the sybsystemprocs database, and owned by the System Administrator. Use sp_version to determine which version of installmaster was most recently run.
Some system procedures can be run only in a specific database, but many of them can be run in any database. You can create your own system procedures that can be executed from any database. For more information, see the System Administration Guide.
All system procedures execute at isolation level 1.
All system procedures report a return status. The following example means that the procedure executed successfully:
return status = 0
The examples in this book do not include the return status.
Beginning with Adaptive Server version 12.5.1, you can declare up to 10,000 variables in a stored procedure. In earlier versions of Adaptive Server, the limit was 2,000.
