Number
|
Severity
|
Text and Explanation
|
4901
|
16
|
ALTER TABLE only allows columns to be added which can contain nulls. Column `%.*s' cannot be added to table `%.*s' because it does not allow nulls.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4902
|
11
|
Cannot alter table `%.*s', because this table does not exist in database `%S_DBID'.
Explanation: Command failed. Check your database for the object not found
and re-enter the command with the correct name.
|
4905
|
21
|
ALTER TABLE failed because page %ld of the system catalog sysindexes in database `%.*s' is not in the cache.
Explanation: Adaptive Server encountered an internal error affecting all
processes in the current database. Report the error to your System
Administrator. Adaptive Server must be restarted and dbcc diagnostics
run.
|
4909
|
16
|
Can't alter %.*s because it is not a table.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4910
|
16
|
Cannot alter table `%.*s' because you are not the owner or a user with System Administrator (SA) role.
Explanation: Adaptive Server could not perform the requested action. The
command violates a permission or privilege restriction. Check the
command and working database context.
|
4912
|
16
|
Cannot replace default to `%.*s.%.*s' because it already has a default bound using sp_bindefault.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4913
|
16
|
Alter table command has unrecognized action. Cannot process.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4914
|
16
|
Cannot alter table `%.*s' because the alter table statement contains multiple identity fields.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4915
|
16
|
Cannot add new identity field to `%.*s' via alter table because the table already contains an identity field.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4916
|
16
|
Cannot add new identity field to `%.*s' via alter table because the number of existing rows (%ld) exceeds the maximum value for the specified precision (%d).
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4917
|
20
|
Failure adding identity column `%.*s' to table `%.*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.
|
4918
|
16
|
Row length (%d) exceeds maximum row length (%d) when adding identity column ’%.*s’ to table ’%.*s’.
Explanation: Command failed due to invalid or illegal request. A server
limit was exceeded.
|
4919
|
16
|
Identity value overflow when adding column `%.*s' to table `%.*s'.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4920
|
16
|
Permission denied. A table can only be altered if the table's hurdle equals the user's curwrite.
Explanation: Adaptive Server could not perform the requested action. The
command violates a permission or privilege restriction. Check the
command and working database context.
|
4921
|
14
|
Permission denied. A table's labels cannot be altered while it is in use.
Explanation: You do not have the permission to execute this command. Have
the object owner or a user with the needed role run this command.
|
4922
|
14
|
Invalid hold label specified.
Explanation: You do not have the permission to execute this command. Have
the object owner or a user with the needed role run this command.
|
4923
|
14
|
Permission denied. A table's maxhold should always dominate its minhold.
Explanation: You do not have the permission to execute this command. Have
the object owner or a user with the needed role run this command.
|
4924
|
14
|
Permission denied. A table's maxhold should always be dominated by the maxhold of the database that contains it.
Explanation: You do not have the permission to execute this command. Have
the object owner or a user with the needed role run this command.
|
4925
|
14
|
Permission denied. User maxwrite does not dominate specified maxhold.
Explanation: You do not have the permission to execute this command. Have
the object owner or a user with the needed role run this command.
|
4926
|
14
|
Permission denied. User minhold does not dominate specified minwrite.
Explanation: You do not have the permission to execute this command. Have
the object owner or a user with the needed role run this command.
|
4927
|
14
|
Permission denied. Maxhold label specified is below previous table maxhold.
Explanation: You do not have the permission to execute this command. Have
the object owner or a user with the needed role run this command.
|
4928
|
14
|
Permission denied. Minhold label specified is above previous table minhold.
Explanation: You do not have the permission to execute this command. Have
the object owner or a user with the needed role run this command.
|
4929
|
14
|
Permission denied. User minwrite is not dominated by specified maxhold.
Explanation: You do not have the permission to execute this command. Have
the object owner or a user with the needed role run this command.
|
4930
|
14
|
Permission denied. User maxwrite does not dominate specified minhold.
Explanation: You do not have the permission to execute this command. Have
the object owner or a user with the needed role run this command.
|
4931
|
16
|
Cannot alter the table ’%.*s’ because it is a system table.
Explanation: Error raised if user attempts to add columns to a system table
when allow updates is off.
|
4932
|
16
|
Dropping a column from a system table is not allowed.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4933
|
16
|
Dropping a column from a replicated table is not allowed.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4934
|
16
|
A column by this name doesn't exist in the table `%.*s'.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4935
|
16
|
Dropping the only column in a table is not allowed.
Explanation: Command failed due to invalid or illegal request.
|
4936
|
17
|
Dropping the column failed while reformatting data on page %d, row %d. This command is being rolled back.
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.
|
4937
|
17
|
Deleting text pages failed. This command is being rolled back.
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.
|
4938
|
20
|
Cannot undo a drop column command because the number of rows on the log record does not match the number of rows on the data page.
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.
|
4939
|
16
|
ALTER TABLE ’%.*s’ failed. You cannot drop column ’%.*s’ because it is being used by an index. Drop the index ’%.*s’ before dropping this column.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4940
|
16
|
ALTER TABLE failed. Dropping an identity column is not allowed.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4941
|
16
|
ALTER TABLE ’%.*s’ failed. You cannot drop a column on which constraints are defined. Drop the constraints before dropping this column.
Explanation: Command failed due to invalid or illegal request. Use sp_helpconstraint for
information on the object.
|
4942
|
16
|
ALTER TABLE ’%.*s’ failed. You cannot drop column ’%.*s’ which has a default bound to it. Unbind the default (object id ’%ld’) before dropping this column.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4943
|
16
|
Dropping a column which is a primary key is not allowed. Drop the constraint (object id `%ld') before dropping this column.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4944
|
16
|
Dropping a column which is a foreign key is not allowed. Drop the constraint (object id `%s') before dropping this column.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4945
|
16
|
Cannot drop the column because cursor `%.*s' is still open. Close the cursor(s) before dropping the column.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4946
|
16
|
Dropping a column from a table which has a constraint associated with it is not allowed. Drop the constraint (object id `%ld') before dropping this column.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4947
|
16
|
Dropping an identity column from a table while identity_insert is `on' is not allowed. Set identity_insert to `off' before dropping this column.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4948
|
25
|
Dropping the column failed while logging data from page %d. This command is being rolled back.
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.
|
4949
|
20
|
The alttab_begin() function is trying to put too many lock requests in the lock_requests[] array.
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.
|
4950
|
16
|
Cannot partition table `%.*s' because it is a system table.
Explanation: The partition clause of the alter
table command allows you to partition user tables that
do not have a clustered index. Partitioning is not allowed for system
tables.
|
4951
|
16
|
Cannot create %d partitions on the table '%.*s' with clustered index because the maximum number of partitions allowed on a table with clustered index is %d.
Explanation: Refer to the writeup for this error.
|
4953
|
16
|
Cannot partition table `%.*s' because it is already partitioned.
Explanation: Refer to the writeup for this error.
|
4954
|
16
|
Cannot unpartition table `%.*s' because it is not partitioned.
Explanation: Refer to the writeup for this error.
|
4955
|
16
|
Number of partitions must be greater than one
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4956
|
16
|
Cannot alter table if REORG command or level 0 scans are active.
Explanation: Refer to the writeup for this error.
|
4958
|
16
|
Cannot partition table `%.*s' because it is in a pre-System 11 database.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4959
|
16
|
Dropping a TEXT/IMAGE column is not allowed.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4960
|
16
|
Lock scheme currently on the table `%.*s' is corrupted. For this version of SQL server it should have been set properly.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
4961
|
16
|
Cannot partition table '%.*s' because it has been partitioned and unpartitioned too many times.
Explanation: Adaptive Server could not perform the requested action. Contact
your System Administrator.
|
4962
|
16
|
To partition: bcp the data out of the table, drop and recreate the table, and then bcp into a partitioned/unpartitioned table.
Explanation: Follow the steps in the message to partitioned a table.
|
4963
|
16
|
Table '%.*s' is already locked in the desired locking scheme.
Explanation: This is an informational message. The command did not execute.
|
4964
|
17
|
Lock scheme conversion failed due to insufficient SQL Server memory. Please retry later when there is less load/users on the SQL server, or ask your System Administrator to reconfigure SQL Server with more memory.
Explanation: See the writeup for Error 4964.
|
4965
|
16
|
Lock scheme conversion on system tables not supported.
Explanation: You can only change lock schemes on a user table.
|
4966
|
10
|
Warning: Table '%.*s' with a clustered index has been partitioned. All data rows are in the first partition and all data insertions will go to the first partition. To distribute the data to all the partitions, re-create the clustered index.
Explanation: The table is partitioned but will not stay balanced unless
you take the specified action.
|
4967
|
16
|
Cannot execute '%.*s' command on table '%.*s', because this table does not exist in database '%S_DBID'.
Explanation: Check syntax and working database.
|
4968
|
16
|
The table '%.*s' you've specified is a system table. Executing the '%.*s' command is not permitted on system tables.
Explanation: Invalid command.
|
4969
|
16
|
The table '%.*s' you've specified is a temporary table. Executing the '%.*s' command is not permitted on temporary tables.
Explanation: Invalid command.
|
4970
|
16
|
Cannot unlock this table because the table is not locked in that mode.
Explanation: Invalid command.
|
4971
|
16
|
This table cannot be locked in '%.*s' mode because it was already locked in '%.*s ' mode.
Explanation: Invalid command.
|
4972
|
10
|
Warning: Empty Table '%.*s' with a clustered index has been partitioned. All data insertions will go to the first partition. To distribute the data to all the partitions, re-create the clustered index after loading the data.
Explanation: Table is partitioned but will become unbalanced with future
inserts. Take the recommended action to maintain partition balance.
|
4973
|
20
|
Row size (%d bytes) exceeded the maximum row size limit (%d bytes) for data only locked format while changing the lock scheme from ALLPAGES to DATAONLY for object ’%.*s’ (ID %d) in database ’%.*s’ (ID %d). The lock scheme for the object was not changed.
Explanation: Consult the System Administration Guide for more information.
|
4974
|
21
|
Process %d was expected to hold logical lock on object %ld.
Explanation: Adaptive Server encountered an internal error affecting all
processes using the current database. Report the error to your System
Administrator.
|
4975
|
16
|
Cannot alter table for lockscheme change because cursor '%.*s' is still open. Close the cursor(s) before lockscheme change.
Explanation: Wait for the process holding the cursor to complete.
|
4977
|
16
|
You cannot run ALTER TABLE LOCK in this database because the 'select into/bulkcopy' option is off. Please check with the DBO.
Explanation: Invalid or illegal command.
|
4978
|
16
|
User aborted ALTER TABLE LOCK change command for table %.*s
Explanation: DDL command aborted.
|
4979
|
20
|
ALTER TABLE LOCK change for table '%.*s' failed: insufficient memory to allocate backout structure.
Explanation: Retry the DDL command when there is more memory available
for the task.
|
4980
|
17
|
No space left in database '%S_DBID'; Use ALTER DATABASE to increase size of database. Else, an old transaction may be active; see Syslogshold table.
Explanation: Check the syslogshold table for long-running transactions.
|
4981
|
16
|
Column offset, %d bytes, for variable-length column number %d exceeds the maximum start offset for variable-length columns in DOL tables (%d bytes). The lock scheme for the object ’%.*s’ was not changed.
Explanation: To change the lock scheme, bulk copy the table out, drop and
re-create the table with the new scheme, and bulk copy data back
in.
|
4982
|
10
|
Due to an internal error the table '%.*s' cannot be converted to new lock scheme. Please contact your System Administrator (SA) for help
Explanation: An Adaptive Server error occurred. Notify the System Administrator.
|
4983
|
10
|
Primary index (indid = %d) is suspect for table '%.*s'. Please check and reissue the lock change command.
Explanation: Check the index and table using dbcc. You may need to recreate
the index.
|
4984
|
10
|
Computed effective expected row size value(%d) for the table '%.*s' with the expected row size value(%d) is invalid. Forcing the default value.
Explanation: This is an informational message.
|
4985
|
10
|
Warning: trigger ’%.*s’ is already enabled.
Explanation: This is an informational message.
|
4986
|
10
|
Warning: trigger ’%.*s’ is already disabled.
Explanation: This is an informational message.
|
4987
|
10
|
Enabling trigger ’%.*s’.
Explanation: This is an informational message.
|
4988
|
10
|
Disabling trigger ’%.*s’.
Explanation: This is an informational message.
|
4989
|
16
|
The trigger you specified (’%.*s’) does not exist. The ALTER TABLE command is being terminated.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
4990
|
17
|
ALTER TABLE ’%.*s’ failed due to insufficient procedure cache. Retry later when there is less load/users on Adaptive Server, or ask your System Administrator to reconfigure Adaptive Server with more procedure cache.
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.
|
4991
|
17
|
ALTER TABLE ’%S_OBJID’ in database %S_DBID (objectid %d) failed due to an internal error. Please contact Sybase Technical Support.
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.
|
4993
|
16
|
ALTER TABLE ’%.*s’ failed. Dropping all columns in a table is not allowed.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
4994
|
16
|
ALTER TABLE ’%.*s’ failed. The number of columns in the resultant table (%d) exceeds the current limit %d.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
4995
|
16
|
ALTER TABLE ’%.*s’ failed. Multiple references to the same column in ALTER TABLE statements are not allowed.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
4996
|
16
|
ALTER TABLE ’%.*s’ failed. Adding non-NULL timestamp column ’%.*s’ is not allowed.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
4997
|
16
|
ALTER TABLE ’%.*s’ failed. Default clause is required in order to add non-NULL column ’%.*s’.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
4998
|
16
|
ALTER TABLE ’%.*s’ failed. Default value cannot be NULL when adding a non-NULL column.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
4999
|
16
|
ALTER TABLE ’%.*s’ failed. You cannot drop column ’%.*s’ on which a primary or foreign key constraint is defined.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|