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 procedure 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 under 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.