Server error messages 2000–2099 – Sybase 11.9.x-12.5 User Manual

Page 181

Advertising
background image

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

Advertising