CHAPTER 6 Adaptive Server Error Messages
855
Server Error Messages 2000–2099
Number Severity Text and Explanation
2001 10 Cannot use duplicate parameter names. Parameter name `%.*s' listed more than once.
Explanation: Check command syntax and semantics.
2002 10 Cannot use variable `%.*s' without first declaring it.
Explanation: Check command syntax and semantics.
2004 16 Procedure `%.*s' has already been created with group number %d - create pr ocedure with
an unused group number
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
2005 18 Maximum procedure %s count exceeded. Limit is %d. Modify the procedure to use
fewer %ss.
Explanation: Command failed due to internal Adaptive Server problem. Perform any
diagnostic action indicated by message. Report the error to your System Administrator.
2007 11 Cannot add rows to sysdepends for the current stored procedure because it depends on
the missing object `%.*s'. The stored procedure will still be created.
Explanation: This is an informational message or a message header. No action is
required.
2008 16 The object `%.*s' is not a procedure so you cannot create another procedure und er that
group name.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
2009 16 Group number not allowed in ESP creation.
Explanation: You cannot use group numbers when creating extended stored
procedures.
2010 16 A procedure by that name already exists.
Explanation: Use a different name for the new procedure.
2011 16 System stored procedures (that is, stored procedures beginning with 'xp _' or 'sp _' and
which are owned by the dbo) can only be created in either 'master' or 'sybsystemprocs'.
Explanation: You tried to create a system stored procedure in a database that does not
allow it. You must use master or use sybsystemprocs, and re-try procedure creation.