Server Error Messages 4500 - 4599

Number

Severity

Text and Explanation

4501

16

 View `%.*s' has more columns defined than column names given.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4502

16

 View `%.*s' has more column names specified than columns defined.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4503

20

 The create view tree has a resdom with no right hand side. View `%.*s', resdom `%.*s'.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

4504

16

 CREATE TABLE failed because there was not enough space to allocate memory for the table.

Explanation: Command failed due to resource limitation. Modify the command to fit available resources, retry when the resource is available, or contact your System Administrator to address the resource problem.

4505

16

CREATE VIEW failed because column ’%.*s’ in view ’%.*s’ exceeds the maximum of %d columns. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4506

16

 Column names in each view must be unique. Column name `%.*s' in view `%.*s' is specified more than once.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

4507

16

 Column `%.*s' specifies storage type %d, which does not currently exist.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4508

16

 Views are not allowed on temporary tables. Table names that begin with `#' denote temporary tables.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4509

10

 Column names in each view must be unique.  An unnamed column is specified more than once in view `%.*s'.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.